Reset data in a form

[AKMonkeyboy]

When I edit a record in a form and am not happy with the changes I can hit the "esc" key and all fields return as they were before I started typing. Is there VBA code I could assign to an event or button to do this? I'd like to be able to reset all fields at once, without coding every field in the form.

 

[LittleSmudge]

Yes,

The ( seemingly ) little known UNDO command

You can call the Undo command on a single control or on the whole Form.

You need the Whole Form flavour
Me.Undo



QED

G LS

 

[AKMonkeyboy]

Thanks. You'd think I would have known that. My problem is my questions never seem to be worded properly for the help file.