A.Browne's Audit Trail - Subforms

[Guest]

Good Morning,

Can anyone tell me if using Allen Browne's Audit Trail would be different
for a main form versus a subform?

I've been using Allen's Audit trail for 3 different forms (all main forms)
and they work great. Now I've added one to a subform & everything works
except logging "EditTo" (it logs everything else).

Thanks Kindly

 

[Allen Browne]

The logic is identical for subforms. No changes needed.

Temporarily disable the error handling. There is most likely a field out of
order, or missing (or mis-typed) in one of the tables--either the temp or
audit most likely.

 

[Guest]

Thanks Allen. I'll double check everything & let you know how it goes.

Rgds

 

[Guest]

Hi again Allen

After doing everything you suggested "EditTo" still does not work. What I
have noticed though is on my form there are three fields that come from a
different table (form is based on a query, which is based on 2 different
tables-related) Could this be the problem? If so, is there a work around?

Thanks for your help.

 

[SIMON HOLLAND]

I DONT Know gabby why dont you go to back to what you was doing be for and
see if you can log in after.

 

[Allen Browne]

It can be done regardless of whether the form's RecordSource is a table or
query.

The temp table and audit table must have the same fields, in the same order,
and preferably with the same name. If not, the wildcard in the SQL statement
won't assign the fields correctly.

The SQL statement should throw an error if you used dbFailOnError. If not
perhaps the event is not being called. You could add a Debug.Print line to
the top of the procedure to see if it is firing.

 

[Guest]

Hi Allen,

I apologize for not answering sooner but I just got back. I will try to
debug to see if it's firing or not and will let you know.
Thanks again for your help.