Create audit trail of changes
Posted on 2001-06-15
I want to create an audit trail of changes that takes place on a single field on a form. I have a field called "StartDate" and need to know when someone changes it.
I would like to capture the previous value and also the new value that was entered, the primary key, and the user ID. Any idea or sample code on how to do this?