Don't Save Changes

[karcher]

I'm having problems trying to create a piece of code that will close a form in either of two ways depending on what the user does.

If the user changes the contents of any of the textboxes, I want the close button to prompt them to save the record.

If they choose "yes", then it should save the record but if the choose "No" it should close the form without saving any changes.

I can get the saving part to work but I can't find a way to prevent Access from saving changes to the record.

Any help is greatly appreciated!

 

[The_Doc_Man]

I think you can get somewhere by looking up the DoCmd.Undo action in the Help Files. This is how you choose to not save a record.

(At least, it is how I do it in MY database.)

 

[Pat Hartman]

The problem is that by the time the Form Close event is fired, the record has already been saved. You need to put the save prompt in the Form's BeforeUpdate event. If they say not to save, then you need to cancel the save event with the following statement:
Cancel = True