I keep getting the write conflict box appear when running some update code. I believe the issue is the code runs some SQL that updates the table, but then the form and table become out of sync.
All the code does is ask the user if the option they choose is correct, then updates a check box if they select yes. That sets the control on the form to true and then runs an update query within the code to make sure the table gets properly updated. Normally that happens when the user checks the box, but since in this instance the box isn't being clicked, I am doing via VBA.
I would guess doing that way is the root of the problem and there must be better methods to it. I did try adding me.dirty = false to the start of the code, but alas, no luck.
All the code does is ask the user if the option they choose is correct, then updates a check box if they select yes. That sets the control on the form to true and then runs an update query within the code to make sure the table gets properly updated. Normally that happens when the user checks the box, but since in this instance the box isn't being clicked, I am doing via VBA.
I would guess doing that way is the root of the problem and there must be better methods to it. I did try adding me.dirty = false to the start of the code, but alas, no luck.