If the update of the Control has not occurred, you can undo this using:
Screen.ActiveControl.Undo
Check Access VB Help on ActiveControl.
--
HTH
Van T. Dinh
MVP (Access)
Quote:
> How do I undo the last change on an edited record on a
> form. the property setting "Undo" basically restores the
> record to the last save. I want to undo only the last
> action. For example, a user changes two fields on a
> record, I want the last field change to be undone only.
> This can be done via user interface using Ctrl Z or the
> undo menu selection but I would like to do it
> programatically in VBA.
> Thanks