How to cancel NewRecord?

[Dean Slindee]

How can I use a button's click event to host code that allows a user to
cancel a new record when one field in the form belonging to that record has
been filled in?



Thanks,

Dean Slindee

 

[Marshall Barton]

How can I use a button's click event to host code that allows a user to
cancel a new record when one field in the form belonging to that record has
been filled in?

As long as the record has not been saved, you can use
Me.Undo
to restore the record to its state before any changes were
made.

You don't really need a button for this. Just train your
users to hit the ESC key twice. (Once if they only wnat to
undo changes to the current control.

 

[tina]

try

Me.Undo

hth