Hi Guru's

Does someone has a code snippet available for closing the complete database when closing the master form

thx

S

Try this...

Private Sub cmdExit_Click()
    DoCmd.Quit acQuitPrompt
End Sub

The acQuitPrompt, ensures that it asks if you want to save, if there are any unsaved changes.

HTH

Mike

Mike
EchoVue.com

Thx

S.
www.scriptingit.be

Looks like you will need to remove the close button from the master form, and give them only one way out of the master form: cmdExit.


mmcdonal

You can also place the docmd.quit command in the unload event of the master form:

Private Sub Form_Unload()
  DoCmd.Quit acQuitPrompt
End Sub

maarten