Assuming you have your own close button, you may consider this:
Have a global boolean variable, say bCloseOK
In the Unload event procedure of the form:
Cancel = Not bCloseOK
In the Click event procedure of your own close button:
bCloseOK = True
' your close stuff here
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244