Write Error on Subform on Update

[Joe Champagne]

I'm using a subform to capture updates to two date fields and a comments text
box. When the user saves their changes I use two queries to capture the
data. The first is an append query to write the data to a second table, the
second is an update query to update the form data comments field to null, as
once the action is complete I want to clear the comments. When I run the
save process that runs the queries I'm prompted with a write conflict error
that the record has been changed by another user..., with three
choices...Save, Copy to Clipboard, Drop Changes. There is no other user, so
my processing is somehow creating this. It is sporadic, with about every 4th
test getting this error. Any idea on how to work around this? Thanks.

Joe

 

[Douglas J. Steele]

Assuming your form is bound, you're "the other user"!

Why are you moving the data to another table? Could you simply capture the
comments in an unbound text box?

 

[Joe Champagne]

Its basically a workflow tracker. The first form is a list of tasks that are
due or overdue. When they are overdue I'm requiring a comment be added.
That comment can be added on the first form, then when the task is ready for
completion the user launches the subform to enter the completion date and
next due date. When they save it I write that data to a table to be able to
report on completions against due dates, and also pull in the comments for
management review of overdue items. When a user navigates to the subform
they aren't editing the data on the main form, which is why I'd like to just
figure out a way to accept the changes as opposed to the user getting
prompted with the write conflict.