Expert: Robert Nunemaker - 2/9/2007

Question
Hi there,

would you be able to give me the code i could use in MS Access so when someone edits the data and tries to close the form, then an error message is displayed asking the user whther would they like to save or not.

Yes = form saved
no = form not saved
cancel = takes back in the form.

Could you give me the VB code for this?

Thanks

Answer
This is actually a very difficult thing in Access because they've tried to do it all for you.  So when you close, any uncommitted changes are automatically saved.  The only way to cut that off at the pass is to put code in the BeforeUpdate event for the form and ask to confirm everytime.