Using the close button on a form to exit access

[Guest]

Hi all,

Is there any way that the close button on a form be used to exit Access. If
so what do I need to do for this to work. I'm using A97 if thats any help

MTIA

 

[SusanV]

If this is a button you have added to the form, use Application.Quit.

 

[John Vinson]

Hi all,

Is there any way that the close button on a form be used to exit Access. If
so what do I need to do for this to work. I'm using A97 if thats any help

MTIA

It would be disconcerting for a lot of users, but yes, you can do
this; in the Form's Close event put code like

Private Sub Form_Close(Cancel as Integer)
Application.Quit
End Sub


John W. Vinson[MVP]