audit trail for subform in access 97

[barrynichols]

morning,

MS KB article 183792 (http://support.microsoft.com/kb/183792/) works
fine for regular forms. However, when it comes to subforms, this is
not the case.

How can I alter the code so that alterations to the subform are
recorded?

Thanks

 

[Allen Browne]

Did you try putting the code into the subform's module as well? Since the
code uses the form's events, you need to use it in each form that needs
auditing.

If you do get stuck, or if you need something more comprehensive (audits
deletions too), see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

 

[barrynichols]

Allen,

You are clearly the MV MVP. Cheers!!