Query running on DoCmd.Quit?

[ts_hunter]

I have a "Exit" button on my main form that executes a DoCmd.Quit. This main form also has a Listbox that is loaded by a query. When I click the exit button, the DoCmd.Quit executes (I ran a debug), but then I get a prompt for the parameter for my query. This used to work fine, but the last few days it has been doing this.

[pbaldy]

You can try a decompile:

http://www.granite.ab.ca/access/decompile.htm

I had a 2000 application that had been working for years start doing something similar after I converted it to 2007. After the Quit, it ran the load event of the form, which had a line looking for another form, which had already closed because of the Quit. Of course that threw an error. I never found out how to actually fix the problem, but was able to trap for the error in the load event to get around it. Stumped a lot of people with that one though.

[ts_hunter]

I found what causes the issue for me, but I don't know WHY it causes the problem.

Below is a screen shot of my form. With no tab control, the exit button works fine. When I added the Maintenance tab with nothing on it, it still worked fine. When I dragged the Maintenance subform onto the Maintenance tab, that is when the Exit button starting giving me issues. Anyone know what the subform on the 2nd tab would do to cause the listbox on the first tab to try and requery during exit?