How do you exit a bound form without saving any changes made?

[IamKJVonly]

I have created a form through the form wizard and it has all the fields bound to corresponding fields in a database record. Therefore I can change any and all fields in a record.


I have a SAVE button so I can save any changes I want whenever I want.
I exit the form with a button called RETURN Pressing that button brings up the macro "close window" the option save is set to no. but it still saves any changes.

My question is How do I get out of this form with out saving any changes I have made on the data in the form? (the SAVE button has NOT been used)
Or perhaps the real question is:
How do I revert to the original data that was in the form before I started making any changes

(the SAVE button has NOT been used)

?

If possible I would like to know how to do it either way.

Any help would be appreciated as I'm always making changes and then wishing I could get back to the original data that I can't remember.
Dave

PS I hope you can follow what I'm saying because sometimes I'm not very clear.

[John_G]

You can prevent changes from saving by using Me.Undo. You would put it in the code/macro that runs if you don't want to save the changes. I don't use macros, so I can't help you much there (!), but I think you want to use a Yes/No message box.

[IamKJVonly]

John_G
Thanks it works beautifully.
The only problem now is that you gave me a good idea about a check box next to my "SAVE" button but since that's an imbedded macro I going to have to change it over to a DoCmd. Thanks for the extra work LOL.