record changes to records

[vjb]

What's the best way to record userID, record#, field name & values before update for every record changed in an access database?
Thanks!

 

[Fizzio]

Call a public function or sub on the BeforeUpdate of the fields you want to track that records this info for you. In the Sub/Function, use a recordset to add new audit records. Search for audit in these forums and that should throw up some useful info.