Copy value - form to form

[Pusher]

Hi all,

I need a history of changes to a table. I wanted to make a copy of a table record to another table with an addition of a date and comment of change. I made a form for changing the table (this table contains the newest state of the record ), any time I change this table with my form I want to make a button that will copy the field records to another form were I can add the date of change and comments. I wanted to make a macro for this but don’t know how

Thanks