closing a form closes access 2

[aw23]

I would like access to close when a form is closed. How do I specify access to close from my code?

 

[src23]

Here is your code:

Private Sub Form_Unload(Cancel As Integer)
If MsgBox("Are you sure you want to quit ?", vbQuestion + vbYesNo, "Confirm ...") = vbYes Then
DoCmd.Quit
Else
Cancel = True
End If
End Sub


Is that what you were looking for ?

 

[TheFitz]

You could also try
Application.Quit
instead of DoCmd.Quit

Hope this helps.

Fitz

 

[aw23]

thanks!