If main form is closed, also quit the application

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Song - 09 Aug 2008 05:51 GMT

I use Access 2007 default tabbed window. If use right click my main form tab
and select close, I also want to quit the application to prevent other
forms/report still open without main form. (some reports refer controls on
the main form). What's the event to quit? I tried on close and on unload the
form event, I could not quit (action not available when form is closed or
unloaded).

Reply to this Message

boblarson - 09 Aug 2008 08:16 GMT

Put this into a new standard module named modClose:

Public Function CloseProgram()
Application.Quit
End Function

And then in the form's Unload event, call

CloseProgram

Signature

Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

> I use Access 2007 default tabbed window. If use right click my main form tab
> and select close, I also want to quit the application to prevent other
> forms/report still open without main form. (some reports refer controls on
> the main form). What's the event to quit? I tried on close and on unload the
> form event, I could not quit (action not available when form is closed or
> unloaded).

Reply to this Message