Hi All,
I have a form in which Employees add or edit information to a table named Insured. I am trying to build an audit trail to who makes chages to this table. I have an audit table that I would like to update with the individuals name, date, and the control they updated on a form. So I assume that I need to insert some code to run After Update on the from control. The audit table is related to the Insured table by the insured ID with a one to many relationship (the one being on the insured table and the many being on the audit table.Any help on the code I should use, or if I can use a macro? I have even thought about creating an append query that runs to the Audit table After Update with the control name coded in and the Date() expression. I would like something cleaner though. Any help is much appreciated.
Saintrav

You need to search this forum for Audit Trail. There are lots of threads on this topic. Here's an off forum link from MVP Allen Browne. Creating an Audit Log

Or in forum links:
01
02
03
HTH
Good luck