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
Brian - 30 Nov 2004 14:32 GMT
> Hello.
> I have a form in which i have a text box with an after update event. This
[quoted text clipped - 8 lines]
>
> Luis
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.