..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.