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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieve data from another table based on criteria 1
date problem with linked spreadsheet 6
Access Updating inventory levels 0
Allen Browne's audit table 1
Carry over data to next entry 5
Bank Account Database Design 5
How do I figure out amout due from transaction file 3
Transactions across subroutines in ADO 2

Back
Top