Hi all,

I'm trying to get something done on the close event of a form.
When the user closes the form, a message box pops up asking "do u want to exit ?" vbYesNo.
If the user says 'Yes' then there are a series of commands and then the application closes. And if the user says 'No' then nothing happens and the form doesn't close.

My problem is I cannot stop the form from closing even if the user says 'No'. How can this be done ?

Thanks

Since the close event does not have a cancel parameter, you will need to move your code to the unload event for the form.

Private Sub Form_Unload(Cancel As Integer)

In your code when the user does not wnat ot exit then use the following

Cancel = True



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Ok. Got it.
Thank you.