Write Conflict message

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

Guest

Hello.
I have a form in which i have a text box with an after update event. This
after update event executes an Update table SQL command. The problem is that
after this event occurs i get an Write Conflict message. I then click on Save
changes button and the error disappears.
I already put the Docmd.setwarnings FALSE command, but the message still
triggers.
How can i prevent this ?

Thanks in advance

Luis
 
Luis said:
Hello.
I have a form in which i have a text box with an after update event. This
after update event executes an Update table SQL command. The problem is that
after this event occurs i get an Write Conflict message. I then click on Save
changes button and the error disappears.
I already put the Docmd.setwarnings FALSE command, but the message still
triggers.
How can i prevent this ?

Thanks in advance

Luis
Click to expand...

It appears that your update is updating the same table/record that the form
is bound to. Why? The usual thing to do would be to set the appropriate
field values in the BeforeUpdate event, and leave it up to the form to
perform the update.
 
Back
Top