Unwanted edit on form - how to revert to initial state?

[RSIboy]

I have an Access database, with very little VBA behind it. I want to be able to check if a user meant to change anything on a form. Using the 'Before Update' property of the form, I have got Access to pop up a box saying 'Record Changed - Save?' with Yes/No - if 'yes' is selected, the change is accepted....

However, if the user selects 'No' - I want the record to revert to it's original state, ignoring whatever amendments the user has made. Is this simple to achieve?

Many thanks

Dale
Manchester, UK

 

[Brianwarnock]

DoCmd.Runcommand AcCmdUndo

Brian

Having read your Post again Me.Undo as the no part of the response should do it.

 

[RSIboy]

Superb... thanks for your help

 

[Kevin_S]

Me.Undo

HTH,

Kev