To copy you use DoCmd.RunCommand acCmdCopy. However, you probably won't want to copy exactly.
The solution you choose will partly depend on what the table looks like where you are moving the data. Does it contain all the fields from your record or is it just storing the FieldName and OldValue?
Also, there is an OnChange Event which would probably be better suited to your needs.