Undo for current field

[gg]

How do I create an Undo button that will do the same thing that the forms tool bar Undo does? i.e., I want to undo only the last changed field in a record when the button is clicked-NOT changes in other fields. The keyboard Escape key will do this from the keyboard, but when a button sends {Esc} via sendKeys, it wipes out all changes. Undo via macro or code does same. I don't give users access to the toolbar, so can't use that.

 

[Schof]

If you say that the Undo button works from the toolbar then you can call the toolbar using the DoMenuItem method.

For Example:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acUndo, , acMenuVer70

or you can try...

DoCmd.RunCommand acCmdUndo