I have an access database with a form frm_main
I need to insert a record into a table (audit log type) every time an update is made in frm_main
tbl_main has field field1 that we need to monitor
tbl_audit has the following 3 fields that need to be updated
fld_previous = value of prior value of field1
fld_new = new value of field1
fld_date = date/time when update occurred
can somebody help me with the vba logic, I would much appreciate it.