Main form's Load Event firing on Application Quit - say what?

[willknapp]

I'm developing in Access 2007 and created a runtime version.

When the user clicks the X to close the runtime application, the main form's Load event fires. Any clues as to why this might be? Some of the code is based on other forms that do close, so of course errors start flying. Note, this is only in the runtime version; the accdb file works just fine.

My current workaround is to put the offending code into the forms On Current event, which I'm able to do in this context.

Is it wrong to think that a forms On_Load event shouldn't be firing when the application is closing?

 

[pbaldy]

It shouldn't be firing, but I had the same problem with an application when I converted it from an A2000 mdb/e to an A2007 accdb/e. I ended up trapping for the error to work around it. Never figured out why the load event was firing, and had smarter people than me unable to figure it out either.