Write Conflict

  • Thread starter Thread starter Salim
  • Start date Start date
S

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
 
Salim said:
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
Click to expand...

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?
 
Back
Top