Audit Log - Allen Browne

[Guest]

I found Allen's Audit Log (http://allenbrowne.com/AppAudit.html), and was
building it into my database. It is properly recording insertions,
deletions, and Edit To, but I'm finding it's not recording the Edit From
record.

The Calling Proc generating the error is AuditEditBegin(), and the error I'm
seeing is 3075: Syntax error (missing operator) in query expression ''EditFr
' pr1'. I have this code in the Before Update event of my form (it's a
subform if that matters):

bWasNewRecord = Me.NewRecord

Call AuditEditBegin("tblData", "audTmpData", "RecID", Nz(Me.RecID, 0),
bWasNewRecord)

Help?

 

[ruralguy via AccessMonster.com]

Put a breakpoint in the AuditEditBegin() code and see what you are passing to
the Function. Why would you ever have a Null in your RecID field?