Audit Trail - Allen Browne - prob with insert

[vfgilber]

Hi,

I have successfully (for the most part) gotten Allen Browne's method of creating an audit trail.

The issue I am having is that the audit log table should indicate in the "Audit Type" cell the word 'INSERT' when it's a new record that was added. I'm just getting the word "EditTo". Usually the EditTo follows an EditFrom record.

Can anyone suggest why the VBA code isn't "seeing" that I'm adding a new record? It seems like the variable bWasNewRecord is not being called for some reason.

Thanks,

Vince

 

[KeithG]

It hard to tell with out seeing the code.

 

[vfgilber]

I followed the instructions on this page to a T.

The major coding is provided in a link on the page
http://allenbrowne.com/AppAudit.html

The major chunk of coding is provided separately in a link on the page
http://allenbrowne.com/AppAuditCode.html

 

[vfgilber]

I found MY error. When I said I followed the instructions to a T, I meant that I had ASSUMED that I followed them to a T. I forgot to cut an paste one line of coding.

Sorry to waste your time.

 

[sun_after_rain]

I have the same problem with Insert! Everytime I insert a new record the "audtype" is Edit To..What is the line of code you left out?