Problem Closing Form

[Ross]

I have a mainform, subform set up. When I do a standard
close of the form, I get an interruption in the closing
process by the underlying queries for combo boxes in the
main form (error like trying to run a query that has
missing data fields that the query can't find).

How can I close a form / subform combination without this
error.

Many Thanks

Ross

 

[Dirk Goldgar]

I have a mainform, subform set up. When I do a standard
close of the form, I get an interruption in the closing
process by the underlying queries for combo boxes in the
main form (error like trying to run a query that has
missing data fields that the query can't find).

How can I close a form / subform combination without this
error.

Many Thanks

Ross

I'm not sure what could be going on here. Do the queries in the combo
boxes refer to controls on the main form, as criteria perhaps? I still
wouldn't expect that to be a problem unless there's something happening
as part of the close process -- an event handler, maybe -- that forces a
requery/recalc of the combo boxes.

A workaround might be to set the combo boxes' RowSource properties to ""
in either the Unload or Close event of the form.

 

[Van T. Dinh]

It is like to be a bug documented in the Microsoft Knowledge Base:

http://support.microsoft.com/?id=811860

 

[Guest]

Dirk,

Perfect (Row Source)

Thank You!

-----Original Message-----


I'm not sure what could be going on here. Do the queries in the combo
boxes refer to controls on the main form, as criteria perhaps? I still
wouldn't expect that to be a problem unless there's something happening
as part of the close process -- an event handler, maybe - - that forces a
requery/recalc of the combo boxes.

A workaround might be to set the combo boxes' RowSource properties to ""
in either the Unload or Close event of the form.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

 

[Ross]

Van,

Thank you. Do you just read this stuff or did you find
it?

 

[Van T. Dinh]

I had this problem before so I did a bit of searching.

 

[Dirk Goldgar]

It is like to be a bug documented in the Microsoft Knowledge Base:

http://support.microsoft.com/?id=811860

Good "spot", Van!