Returning controls to their Original values

[trekgoes2malaysia]

In a control on one of my forms, if a user tries to enter values that
already exist in the data table (duplicates) , I have a messagebox
appear telling them the record already exists. My problem is
thereafter, I want Access to return to the original values that were
present in the control before the user tried to enter different ones.
How can I do this?

 

[Stuart McCall]

In a control on one of my forms, if a user tries to enter values that
already exist in the data table (duplicates) , I have a messagebox
appear telling them the record already exists. My problem is
thereafter, I want Access to return to the original values that were
present in the control before the user tried to enter different ones.
How can I do this?

Nice and easy: Me.Undo

 

[trekgoes2malaysia]

Nice and easy: Me.Undo

Thanks, It worked.

 

[Linq Adams via AccessMonster.com]

And just FYI, <Esc> does the same thing!