It sounds like what you're saying is that a partial record is already entered, but not all required fields are filled in or that there is some code preventing this record from being saved, but hitting the Esc key undoes the changes. So, in code, Me.Undo should have the same effect. HTH