audit log

[Guest]

I'm using Allen Browne Audit log. It is a great tool!!!

I have a master table with detail info in another table. The Audit log is
not recording the changes. (one-to-many relationship)

Any suggestion?

Thank you for your help!

 

[Allen Browne]

You need to log the changes to the main form and subform separately, i.e.
separate tables (if the main form and subform are bound to different
tables), and use the events of the subform as well as the main form.

If you are doing that and the logs entries are not being inserted,
temporarily comment out the error handler in each routine, by adding a
single quote to the beginning of the line:
'On Error Goto...
at the top of each procedure. Then when it fails, you will be able to
debug.print the SQL statement that failed, and figure out what's wrong with
it.