Re: Closeing form problem

You have put a break point at Docmd.Close acForm, Me.Name and then
stepped through the following code with <F8>?


On Jul 31, 8:29 am, Salad <o...@xxxxxxxxxxx> wrote:
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.

.

Quantcast