How to Cancel an Unsaved Record

[bullfrog83]

My main form has a tab control. Each tab contains a table bound subform in which you can enter records. My one subform has a couple of combobox controls that are bound to required table fields. If I'm beginning to enter a record but change my mind half-way through selecting values in all the required fields and click on a different tab to cancel out, I get the error that I have to enter a value for the next required field. At this point I'm stuck (unless I decide to just select values anyway and then delete the record which I don't want to do). The only way I can get out is to close the form entirely so I get the "You can't save this record at this time" error and I select Yes to wanting to close the object. This will be bad for my users because closing my main form will require them to close out of the application entirely and reopen it since they won't have access to the NavPane to reopen the form. Therefore, how do you cancel an unsaved (or is it "uncommitted"?) record?

[TheSmileyCoder]

You can press ESC to undo your current record. You can also make a undo button, with code:

Private sub btn_Undo_Click()
  Me.Undo
End Sub

[bullfrog83]

Thanks for your help!