What is the best way to record the fields changed, user, and time.

R

Renae

What is the best way to record the fields changed, user, and time for each
field that is modified. Is there a way to do it without creating a query &
macro for each field?
 
A

Allen Browne

Hi Renae.

Big question. You need to do that in the AfterUpdate event of the form, when
you know that the changes have been made. But at that stage, the OldValue of
the controls is no longer available, so you need to record those in the
BeforeUpdate event of the form, so you can compare them.

There's an example of how to record inserts, edits, and deletions in:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html
 
Top