Write Conflict

[Salim]

Hi there,

I am using an update query (DoCmd.RunSQL) to update the value of a
field of the record that is being displayed on the form from which the
sub is called.

When I then refresh the form (Me.Refresh), I get a write conflict error
message: "This record has changed by another user since you started
editing it. If you save the record, you will overwrite the changes the
other user made."

Please note that I am refreshing the form just before running the
update query.

Cheers,

-Salim

 

[Baz]

Hi there,

I am using an update query (DoCmd.RunSQL) to update the value of a
field of the record that is being displayed on the form from which the
sub is called.

When I then refresh the form (Me.Refresh), I get a write conflict error
message: "This record has changed by another user since you started
editing it. If you save the record, you will overwrite the changes the
other user made."

Please note that I am refreshing the form just before running the
update query.

Cheers,

-Salim

Why not just change the field's value right there in the form instead of
sneaking behind the form's back with an update query?

 

[Salim]

I have changed my code to do this. Thank you.