Unfortunately, I was unable to resolve my issue from the previous thread so I am starting a new thread.
I have a unbounded mainForm with a tab control. Each tab contains it's own subForm that is bounded to it's respective tables. I need to implement an audit trail for data entry and updates for each of those respective subForms that allow data edits. I was trying to implement this Microsoft KB Article solution and followed the previous thread along with Allen Brown's suggestions but with no success. I looked into Allen Brown's own version of an audit trail but it seemed to complicated.
The error message that I am getting when I attempt to update a record states "The expression Before Update you entered as the event property setting producted the following error: The expression you entered has a function name that [Form Name] can't find." In that subForm, I have the "=AuditTrail([Form])" in the BeforeUpdate event.
Any help would be most appreciated.