Saving the current record of a form before updating into another table

[Frederic74]

I am pretty new to access, so forgive me.
I would like to safe one record from a form and safe this record before it's being changed to another table.
I have created an append query to append from my form's recordsource to another table. I have selected the record in my query using criteria expression which is a reference to the id field on the form: forms!myform!myidtextbox. So if I had a Commandbutton I could simply run the query. However I would like it to be saved to the other table once a change is made to the record. I have tried it with data change and before update event, but I am new to Visual Basics, so probably the mistake lies there. Any help would be much appreciated...

 

[ineuw]

You can save a record only to a table. Save the record to a temporary table before you transfer it to the final table. After successful transfer, delete the temporary record.