Second form opened from Form_Load event - relaunches in non-responsive format when closing database

[Travb81]

Hello,



I have a line of code in the Form_Load event of my main menu form....

DoCmd.OpenForm "frmNotes", acNormal, , , , acDialog

The code on the second form, to close itself is simply:

DoCmd.Close acForm, Me.Name

For some reason, when I close my database, the frmNotes is opened again, but in a non-responsive state. I can't use any controls to close it.
It occurs after all other forms have been closed, and i have to terminate the task.

I note that since frmNotes is opened from the Form_Load event of frmMenu, it is displayed before frmMenu is displayed.

If i change my first line of code above, to open the form without being modal/dialog mode, the frmNotes is still being launched on the Quitting of the application - but as it's no longer modal, it doesnt display. I know it's being loaded as i've got a beep event in a frmNotes routine.


Why is this form loading by itself on application closing?

Thanks

[Bob Fitz]

Have you checked that your OnLoad code hasn't been copied to some other event like the UnLoad event or the OnClose event.

[Travb81]

Have you checked that your OnLoad code hasn't been copied to some other event like the UnLoad event or the OnClose event.

Hi Bob,
Yep. I searched for my OpenForm statement, and doesn't appear anywhere it shouldnt.
Also commenting out the line, the database functions normally without this behaviour.

It's something to do with the frmMenu, and that being set as the default display form.
If i move my OpenForm statement to the load even of another form, i dont have this glitch....
It's repeatable - happy to knock up a simple demo file if you'd like?
Cheers

[Bob Fitz]

Yes. Can you post a copy of the db