Help this Audit Trail in Access 97

  • Thread starter Thread starter LizI3
  • Start date Start date
L

LizI3

I have copied the code on how to crate an Audit Trail of a
Record Changes in a form from the Knowledge Base article
183792 into my form. My problem is that my form has a
subform and I cannot get te audit trail to capture changes
made to the subform. Has anyone had this problem and
found a solution? Any suggestions would be very welcome.

Thanks Liz
 
The subform records will need to be audited separately. Did you try adding
the code to the subform as well? (Haven't tried it.)

If you need to audit deletions as well as edits, there is a different
approach explained in this article:
http://allenbrowne.com/AppAudit.html
 
Thank you very much Allen I did put the code in both the
Main form ( which contains the subform) and on the Subform
itself. I have to change the myform set to the subform
name rather than Screen.Activeform but finally it WORKS

Thanks again
Liz
 
Back
Top