Run-time error on acCmdDeleteRecord

[Guest]

All I want to do is close a form without saving anything in the text boxes.
If IsNull(txtUserName) Then
DoCmd.Close acForm, "Edit - Add new user", acSaveNo
Call OpenControl
Else
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.Close acForm, "Edit - Add new user", acSaveNo
Call OpenControl
End If
I figured this would not be so hard to accomplish. The true side works
fine. But if something is in the box I receive a run-time error and "The
command or action 'DeleteRecord' isn't available now." I don't know
why....could someone please help me.

Thank you

 

[Guest]

That is because if you are in the process of adding a new record, it really
isn't a record in the table yet. You don't delete it, you Undo it.

Else
Me.UnDo
Call OpenControl

 

[Guest]

Thank you That did it

That is because if you are in the process of adding a new record, it really
isn't a record in the table yet. You don't delete it, you Undo it.

Else
Me.UnDo
Call OpenControl