Audit User Changes to a Subform

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

I have used article 197592, which outlines how to Record
Changes in a Form, but this process does not work for my
subforms. What do I change in the module to make this
work?

Could I make a change to the following:

Set MyForm = Screen.ActiveForm
 
The subform will need auditing separately from the main form, but that's not
difficult to do.

Change the declaration of the function to:
Function AuditTrail(frm As Form)

Then change the form's BeforeUpdate property to:
=AuditTrail([Form])

If you need to audit deletions as well as edits, see:
http://allenbrowne.com/AppAudit.html
 
Back
Top