Help Needed With Write Conflict Error Message.

[Terry]

I have an order form that users open and close on a regular basis. The form
is based on a query. On the form are two fields, "TicketPrinted" and
"RevisedDate". Most of the time the field "Ticket Printed" has a value in
it of "Yes". What I want to be able to do is that if a date is entered into
this "RevisedDate" field, OR if the information is changed in this "Revised
Date" field, that when the user closed the form, an update query runs that
changes the "TicketPrinted" field from the original value of "Yes" to "No".

However, since the form is based on a query, when I attach code to run this
update query to the AfterUpdate event of the "Revised Date" field on the
form, I get a Write Conflict error message . If I choose Save Record, the
update query does not run, but if I choose Drop Changes the update query
runs correctly.

Does anyone have any suggestions on how to stop this Write Conflict Error
Message?

Thanks,
Terry