My Audit Trail Isn't Working

63 Views Asked by At

I am having a problem getting my audit trail started. If I change "Item Number" on tbl_MBRSummary, a record should be made on tbl_AuditChanges_Tables. This isn't happening and I don't know why. I followed directions to a T from ScottGem... Is there something wrong with this setup?

Screenshot of current DataMacro

1

There are 1 best solutions below

1
On BEST ANSWER

The macro you're showing us is for Tbl_AuditChanges_Tables, not for Tbl_MBRSummary, and thus won't trigger when you're updating that table.

You need to create the macro on the actual table you're changing, and you need to make sure the If statement actually includes a field you're changing. If you do that, it should work.