DeleteRecord

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem with closing a form without saving a record.
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
When I run this code the true side is fine. On the false side I receive an
runtime error and "The command 'DeleteRecord' isn't available now" I don't
know why....could someone help me on this.
Thank You
 
Not sure exactly what you are doing, but if the idea is to close the form
without saving the any edits that are in progress, this should work:


If Me.Dirty Then
Me.Undo
End If
DoCmd.Close acForm, Me.Name
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error on acCmdDeleteRecord 2
DeleteRecord command failing 1
Command acCmdDeleteRecord on Subform 7
datasheet view 2007 without saving column layout changes 2
Cancel timer event if criteria not met 1
close 1 form while opening another 1
Prevent BeforeUpdate code on Delete - Me.Undo not working 2
Access Choosing Printer VBA Access 0

Back
Top