I have created a updated query (UPDATE ELAW SET ELAW.ChargeOutTo = Null, ELAW.unitCode = Null, ELAW.DateOut = Null
WHERE (((ELAW.FileNoFull)=[Forms]![ChargeOut]![txtFileNoFull])), but somehow when I ran this query from the form ChargeOut. I will get an error message box popped up saying Write Conflict: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.
Is this sth wrong with my query? or sth else?
Please help!
Thanks
WHERE (((ELAW.FileNoFull)=[Forms]![ChargeOut]![txtFileNoFull])), but somehow when I ran this query from the form ChargeOut. I will get an error message box popped up saying Write Conflict: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.
Is this sth wrong with my query? or sth else?
Please help!
Thanks