Occasionally, I run into an issue where I am using some function within a BeforeUpdate event in an Access form which goes and updates the table with a SQL statement or query. This can produce some unwanted and messages about someone else editing the record and do you want to Copy or Discard your changes:

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. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.

Annoying Access error message

This occurs when trying to save the record after running an append or update query during the BeforeUpdate procedure. There are a couple of techniques you can use to try to avoid this situation.

1. Can you move the append / update query to execute at a time after the record is saved?
2. If you want to revert the changes you’ve made in the form, you can do a Form.Undo procedure, which will undo any of the changes you or the user have made up to this point.
3. Examine your update query. Can you exclude your record with a unique ID and then use code to make the updates you need to make via the form?

This is a very frustrating problem to experience, but hopefully one of these techniques can help you.