Referential integrity - cancel record

[hbrems]

I have refential integrity turned on in my relational database.

Suppose a record is created by accident in a form and the user wants to cancel this record he will get a prompt saying that the record needs a value in the related field.

How to abort a record with vba (so I can create a cancel button)?

 

[KeithG]

Me.Undo

the above should work if you put it on the forms Class Module

 

[hbrems]

Actually I've just found the following:

RunCommand acCmdUndo
RunCommand acCmdRecordsGoToPrevious

Is this also valid?

 

[PatrickP]

I have refential integrity turned on in my relational database.

Suppose a record is created by accident in a form and the user wants to cancel this record he will get a prompt saying that the record needs a value in the related field.

How to abort a record with vba (so I can create a cancel button)?

Although not perhaps as neat and foolproof as a Cancel button, if the User didn't intend to enter anything in just one field but the rest of the form is valid they can always exit the field by pressing Esc and left or right arrow.