Why are Listboxes requerying after the form has closed?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2000 database that was in Windows 2000 and is now running in
Windows XP. The forms contain listboxes connected to parameter queries. It
looks like when the form is closed the listboxes try to requery, but since
the form is closed it can't find the parameter.

There is no code that does this, it seems to be doing it on it's own.

How can I fix this.
 
Morgan,
Do you mean to say that when the form is closing, the
close event fires off a requery? Or is the case that when
the form is closed it suddenly fires off an event?
Geof
 
Morgan Delvanna said:
I have an Access 2000 database that was in Windows 2000 and is now
running in Windows XP. The forms contain listboxes connected to
parameter queries. It looks like when the form is closed the
listboxes try to requery, but since the form is closed it can't find
the parameter.

There is no code that does this, it seems to be doing it on it's own.

How can I fix this.
Click to expand...

I suspect it's the bug described in this Microsoft KnowledgeBase
article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811860
BUG: Enter Parameter Value Dialog Box Appears While Trying to Close
a Form Window

In addition to the workarounds mentioned there, you might try clearing
the RowSource properties of the listboxes in question before you call
DoCmd.Close.
 
Back
Top