In my access application, I have a form where the user gets a display of data such as name and address. On that form I have 3 buttons, one that says edit, the other says save, and another that says cancel.

When the user clicks edit, it runs code to enable the form for editing and makes the cancel & save buttons visible and active. When the save button is pressed it updates the table and sets the form not to allow edits and disables the cancel button. Now here is my question: How can I code the cancel button so that if the user clicks the "edit" button and makes corrections, but changes there mind then clicks cancel... wanting everything to go back to how it was?

I did notice that on the menu bar, you can choose undo and it will undo everything you have edited on the form so i know it exists. Any help is much appreciated!!

Chris