Patrick O'Dea
asked on
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
..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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER