Need to add a record to a table

[abada]

I need to add a changed record to a history table using the "on dirty" event. I don't know how to code this. Any suggestions?

[OBP]

There are a few ways to do this, you can use VBA created SQL, run an append query or use a form in add mode. The easiest is to run an append query.