Audit Log - Allen Browne


G

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?
 
Ad

Advertisements

R

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top