Cancelling current record

J

John

Hi



How can I cancel the current record that user has just inserted, changed a
few fields and is still on it i.e. not saved?



Thanks



Regards
 
C

Conan Kelly

John,

You should be able to accomplish this by hitting the [Esc] key a couple of times.

Hitting it once should cancel any changes to the current field/column. Hitting it again should cancel changes to the whole record.

HTH,

Conan Kelly
 
J

John Vinson

Hi



How can I cancel the current record that user has just inserted, changed a
few fields and is still on it i.e. not saved?
Click to expand...

Me.Undo in VBA code on the form; or hit the <Esc> key twice (once to
cancel the current field, once to cancel the entire record).

John W. Vinson[MVP]
 
J

John

Thanks. Me.undo works for me but the record still remain on the new one how
can I move the form to the last record?

Thanks

Regards
 
J

John Vinson

Thanks. Me.undo works for me but the record still remain on the new one how
can I move the form to the last record?
Click to expand...

Me.Undo
DoCmd.GoToRecord acForm, Me.Name, acLastRecord

John W. Vinson[MVP]
 
Top