database - MS Access VBA code for making a copy of the old record -

database - MS Access VBA code for making a copy of the old record -

hi have 2 tables auditsheet2 , sheet2. new vba , question is possible if user updates of fields in row of sheet2 create re-create of old record in auditsheet2.

so illustration have 10 columns in sheet2 , if user makes changes in row 1 or multiple feilds record want one record created in auditsheet2 table old feilds.

can please help me have searched weeks , have been unable figure out.

thanks

starting access 2010 can utilize after update macro. next msdn article has illustration similar desire. inserts new record in comments table. can start illustration , insert new record in audit table using old values instead (via [old].[field name]).

after update macro event on msdn

database vba access-vba ms-access-2010