Record Not Saving

Question

Trying to save a record on a form with save button - but getting 'action was canceled' msg and not allowing save or move to next record.  I have tried with DoCmd.DoMenuItem and DoCmd.RunCommand acCmdSaveRecord.  Not sure where to check to clear this message.  I have seen the message before but can usually click OK to procede.  

---

SteveStad

Answer 1

Marshall - it was the a'cancel = true' line in the form before update event for a piece of code that updates a check box if the vac_date_it_01_beg date is filled in.  I removed the line and the record saves now.  

Thanks.

---

SteveStad

Answer 2

That can happen if the record would violate referential integrity, fails a validation rule, the form's BeforeUpdate event cancels the update or, depending on your record locking, if another process or form is also modifyng the record.

Try saving with:

   Me.Dirty = False

and see if you can get a more meaningful message.

Answer 3

in the onclick event of your save button try:

If Me.Dirty=True Then Me.Dirty=False

Also, add in error handling so if you get any errors you get the Err.Number and Err.Description.  These will help us troubleshoot further.

---

Daniel Pineault, 2010-2011 Microsoft MVP

http://www.cardaconsultants.com

MS Access Tips and Code Samples: http://www.devhut.net

Answer 4

Please use the on click event procedure of the save button.