Transaction Date of Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got this code [TranDate] = Now in the Before Update event of my form
that captures the transaction date of the record. It works fine, but what
I'd REALLY like is to create a new record with the current TranDate. I want
an audit trail of all changes to a record, not just the most recent change.

What's the best way to accomplish this?
 
See:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

It is a matter of creating the audit record in the form's AfterUpdate and
AfterDelConfirm events. However, you need to use the BeforeUpdate and Delete
events as well, so you know if it was a new record and which records were
deleted.
 
Back
Top