This record has been changed by another user

I have a form which when closed I get a write conflict message... This record has been changed by another user, etc.

The data behind the form has been updated with a update query prior to closing the form.  I've tried DoCmd.RunCommand acCmdSaveRecord in the form's close event but that doesn't work.

How can I get rid of this message?
SteveL13Asked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
If the user is able to edit data in this form, try placing your DoCmd.RunCommand acCmdSaveRecord immediately BEFORE running your update query.
0
 
SteveL13Author Commented:
Didn't work.  Still get Write Conflict message.
0
 
mbizupCommented:
Can you post a sample database?  There are a lot of different factors that could be causing that. Without seeing your actual code/forms, it is a guessing game as to what needs to be fixed.
0
 
SteveL13Author Commented:
Actually this did work.  I had the line of code in the wrong place.  Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.