insert one table and update other at same time

[Reinier11]

What is a good (the best?) way to append a record to a history table, after a user has updated the current record? I have a form wich is based on a table that must be updated, but the updated record has to be 'stored' in another table that contains the 'history'.
Before I start coding, has anyone done something alike? I would appreciate any help.
Gr,
R

 

[Rick39]

You might consider attaching code to the Save button that would fire an append query for the current record to the history table.......

 

[Reinier11]

The thing is I wasn't sure witch event I wanted to fire the append query and if I wanted to use a temorary table.
I do now use just a bound form and an append query fired by the afterupdate-event of the form. works fine till now.
Thanx for the remark anyway.