Allen Browne's Audit Log and tips

[MartyO]

Hi there. I need to create a log of changes to two tables that are updated
with one form. I found the answer to my question in another post. It almost
gets me there. Allen Browne answered that post with this referrence
http://allenbrowne.com/AppAudit.html

I incorporated this code and application tips into my code and app....and it
works great... on one table.

If the form is driven by a multi table query, can a log be created for both
tables with the use of that one form?
It's updating the one audtablename just fine, but not the other one. I have
two sets of audit tables for the two tables that I want to track, and simply
made the same calls in the form events for both. But only the one table is
getting updated with the changes.

Thanks in advance!
Marty

 

[Allen Browne]

As it stands, the code is designed to handle one table.

You could make an audit table (and temp table) that contains all the fields
from both tables, in exactly the order they appear in the RecordSource of
your form. It should work with that, though that's not telling you which
field from which table was updated.

Alternatively, you could write your own code using the same events.
Determine which fields changed, so you know which ones you have to log. You
can use the SourceTable property of the Field in the RecordSource of the
form to determine which talble the field came from.

 

[MartyO]

Okay, thanks Allen...that's what I thought, but decided to ask before
spending time writing code. Thanks for the tips, I had not thought of the
SourceTable property for the fields in the tables.

Marty