I have an A97 MDB that I converted to A2003 yesterday. My MainMenu
calls ARInfoForm. I hit the Exit button in ARInfoForm and it closes and
displays/activates the MainMenu just fine.
The ARInfoForm has a complicated recordsource that makes reference to a
couple of checkboxes on the ARInfoForm. Like
Forms!ARInfoForm!CheckBox = True
In A2003, when I open the form ARInfoForm and close it via the Exit
button it appears to close, displays/activates the MainMenu and then it
pops up behind the MainMenu and I am prompted to enter the value for the
parameter
Forms!ARInfoForm!CheckBox
Do you have any idea why it appears to execute a call to the
recordsource of ARInfoForm when it closes...like it's doing a requery on
a closed form? My Exit button is simply
Docmd.Close acForm, Me.Name
There's no Unload event and in the OnClose event I simply check to see
if another form open and if so close it. There's no Before/After update
event for ARInfoForm.