Same Code - Different results

Hi,

..I have tried multiple fixes here but no joy .. 3 hours later..

I have written an audit trail.
There is an additional "memo" field on each record "Auditmemo".
 (Uses OldValue etc).

The audit trail works perfectly on form "AA_ThisWorks". (Note the unique record ID in grey on left of screen).  
The before update event of form is "=audit()".

All good so far!
However, when I try to use this audit trail on another form or table  ... the following happens.

PROBLEM: See AA_ThisFails
If there is more than one change to a single record then ONLY the last change is recorded in the "Auditmemo" field,

WHY ??  This works fine in AA_ThisWorks

(The Audit buttons on the screen may help to understand my problem).
I have hidden some forms/tables from view for simplification


All Help greatly appreciated on this one .... it has been frustrating me for hours.



Database1.zip
Patrick O'DeaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
test this

modified codes in the function audit
Database1.accdb
0
 
Patrick O'DeaAuthor Commented:
Perfect - thanks once again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.