Write Conflict - tried everything

[Guest]

I am getting a write conflict and have tried everything under the sun and
can't figure out why.

I get the error everytime I add a record to the subform and try to move to
the next record in the subform. The only thing that automatically updates is
a field that sets the Envron("UserName") and a timestamp. I have added.
If me.dirty = true then
me.dirty = false
End If

on both the OnDirty event of the main form and the subform. The
relationships are set (one to many).

There are bit fields, but those all are set to have a default of 0.

I can't think of anything else to try - PLEASE HELP

 

[John W. Vinson]

I am getting a write conflict and have tried everything under the sun and
can't figure out why.

I get the error everytime I add a record to the subform and try to move to
the next record in the subform. The only thing that automatically updates is
a field that sets the Envron("UserName") and a timestamp. I have added.
If me.dirty = true then
me.dirty = false
End If

on both the OnDirty event of the main form and the subform. The
relationships are set (one to many).

There are bit fields, but those all are set to have a default of 0.

I can't think of anything else to try - PLEASE HELP

What are the Recordsource properties of the form and the subform? A write
conflict suggests that you have two operations (a form and a subform, a form
and some code, other possibilities) attempting to update the same record.

John W. Vinson [MVP]

 

[Guest]

Yes, about 1 am I remembered that I had put a trigger on one of the tables
for auditing purposes - DUH. Fixed the trigger and now all is fine.