Don't update

[Jim]

After a text box is updated on a form I want to pop a
message box confirming the change. Got that working, but
if the user says No to the update I need the box to revert
back to the original entry. Should be easy, but I can't
get it to work. Any help would be appreciated, thanks.

 

[Rick Brandt]

After a text box is updated on a form I want to pop a
message box confirming the change. Got that working, but
if the user says No to the update I need the box to revert
back to the original entry. Should be easy, but I can't
get it to work. Any help would be appreciated, thanks.

Me!NameOfControl.Undo

 

[Guest]

I tried that and it didn't work. What property does the
procedure need to be in?

 

[Rick Brandt]

All such validation should be done in the BeforeUpdate event for the
control because that one can be cancelled to prevent the update (rather
than trying to change the entry back after it is updated).