audit trail for subform in access 97

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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

wrote in message
...
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,

You are clearly the MV MVP. Cheers!!