Hello! I have a message box in the unload portion of my ONE form. When the user clicks yes, it will run some code and then close. When they click no or cancel, i don't care which, it simply returns the user to the form without closing the database down.
like if a person tries to close out of access, because the form is to always be up hence the need for a message box asking if they really want to close it, the message box pops up. "Click YES if you want to log-out. Click No/Cancel if you are not yet ready to log-out."
yes runs code and closes as normal, no/cancel returns the user to the form without closing access. it sounds simple, but thats just me.