[AccessD] Audit Trails

Dear List:

I am developing an application where the user needs to record changes to
fields in several tables - table name, field name, old value, new value,
date/time of change, user name.

What is the best approach to this? 

Is .OldValue available after the record has been updated?  If so I could
loop through the bound fields checking for changes and add an audit trail
record if changed. 

It would be nice to have this audit trail function packaged in one function
that could be called form anywhere in the app since several tables will have
the requirement.

 

MTIA

 

Rocky