after delete record. go to new record

[deb]

I would like to be able to click the delete button on my form (which has a subform)and have it delete the record and then have the form set to New Record.
Below is my code but it bombs on moving to a new record New record
msg... the command or action RecordsGoToNew isn't available now.

Can you help??


Private Sub btnDeleteCI_Click()
On Error GoTo Err_btnDeleteCI_Click

Me.AllowEdits = True
Forms!f2CustImpactsEdit.Form!f2CustImpactsEditDetails.Form.AllowEdits = True
Me.AllowDeletions = True
Forms!f2CustImpactsEdit.Form!f2CustImpactsEditDetails.Form.AllowDeletions = True
Me.AllowAdditions = True
Forms!f2CustImpactsEdit.Form!f2CustImpactsEditDetails.Form.AllowAdditions = True

Msg = "Are you sure you want to delete this Customer Impact? This will delete the entire Customer Impact record."
Ans = MsgBox(Msg, vbYesNo)
If Ans = vbNo Then
MsgBox "The Customer Impact has NOT been deleted."
Exit Sub
Else
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
MsgBox "The Customer Impact has been deleted."
End If

Me.Refresh
Forms!f2CustImpactsEdit.Form!f2CustImpactsEditDetails.Form.Refresh
DoCmd.RunCommand acCmdRecordsGoToNew

 

[VicRauch]

Are you trying to go to a new record on the main form or the sub form? I would also suggest you use DoCmd.RunCommand acCmdRecordsGoToNew rather than the DoMenuItem. The RunCommand is much easier to follow.

 

[deb]

Both main form and sub form. I need it to be ready for a brand new record after the old record is deleted.

Thanks

 

[VicRauch]

Are you deleting a record from both the main form or are you deleting a record from the subform? Or, when deleting a record from the main form, all records in the subform are deleted? Can you delete a record from the main form, or from the subform? If deleting a record from the main form, you want to go to a new record on the main form? If you delete a record from the subform, you want to go to a new record on the subform? If you delete a record from the main form, do you want to go to a new record on the subform? If you delete a record from the subform, do you want to go to a record on the main form?

Sorry for all the questions, but without some real specifices here, it is just a guessing game as to what you actually want.