Cancelling current record

  • Thread starter Thread starter John
  • Start date Start date
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
 
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
 
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]
 
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
 
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]
 
Back
Top