Audit Trail in Forms

[K Clauberg]

I found a great article (ID 183792) on the Microsoft Self Service database
that addressed setting up an audit trail in Forms for changes, etc to data
fields. This works great! I would like to use it in a form that is a
subform of a Master form, however, and it does not work that way. Can
someone help me change the code so that it works in a subform? Thank you.

 

[Allen Browne]

At step 5, replace the line:
Set MyForm = Screen.ActiveForm
with:
Set MyForm = Me

The main limitiation of the approach in that article is that it does not
audit deletions. If that is important to you as well, see:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html

 

[K Clauberg]

Would the code be placed into the master or child form? Thank you for your
help!

 

[Allen Browne]

Place the code into the event of the form you wish to audit.

You could audit both the form and the subform if you set up for both of
them.