My Audit Trail Isn't Woking

[lccrews]

I'm not sure why, but the data macro I am using for my audit trail isn't working. Any idea as to why? I followed directions from https://scottgem.wordpress.com/2012/...data-macros-2/ to a T.

[CJ_London]

what does 'isn't working' mean?

[lccrews]

Meaning, when I update [Item Number] on tbl_MBRSummary, a record isn't created on tbl_AuditChanges.

[CJ_London]

unfortunately macros do not have any error handling, and I avoid them like the plague for that and other reasons

Suggest go back to the author - he seems to have had plenty of questions from others not being able to get it to work - see what solutions he has suggested and try those.

My observations: You have not followed his design exactly - Tablename in his example is text, in yours it is called Formname and is a table object, and have you created the function fosUserName, and do you know if it works?

[lccrews]

Thanks for the response Ajax, I need to comment on ScottGem's thread. I changed the names to suit my database. I do not know if fOSUserName() works and have tried removing it.

[CJ_London]

see this comment from your link

In this example I am using the fOSUsername() function found at http://www.mvps.org/access (see Note).