Audit Trail

[sxschech]

Something I usually do when finding suitable code is copy the weblink and the date I put into my database. That way even if the code itself didn't contain the notice (which I keep as well if it is included in the code), there is still a reference from where it came from (of course that does not rule out that the original source of the code was from somewhere else).

'https://www.access-programmers.co.uk/forums/threads/audit-trail.324261/#post-1838647
'20220804

 

[jdraw]

The Martin Green audit trail has a variety of shortcomings as note in the link referenced in post #8.
-identifies the wrong record in the log
-does not handle subforms

 

[Pat Hartman]

My apologies but I did start off trying to use Allan Browne's Code but it did not deal with a Subform.

A subform is a form. If you put the audit log code in the correct event of a subform, it will work just fine. If you try to do the logging from the main form, you won't be able to because the mainform doesn't "see" the subform events.