[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

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?
0
SteveL13
Asked:
SteveL13
  • 2
  • 2
1 Solution
 
mbizupCommented:
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now