What I'm trying to achieve is that when the value of the 'Location' field is modified in a record in the 'Assets' table, once the user clicks the save button the record should be saved normally and a copy should be appended to the 'AssetMovements' table.
The problem is that my current query appends all the records in the 'Assets' table to the 'AssetMovements' table. I want only the current record to be appended. Also, I want the query to only run when the value of the Location field is modified.
Below is my VBA code for the button's OnClick event:
Expand|Select|Wrap|Line Numbers
- DoCmd.RunCommand acCmdSaveRecord
- DoCmd.OpenQuery "AppendQuery"
Thanks.