Problem Closing Form

  • Thread starter Thread starter Ross
  • Start date Start date
R

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
 
Ross said:
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
Click to expand...

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,

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)


.
Click to expand...
 
Back
Top