Do you the example?
Achi _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of L Tumbulu Sent: Thursday, November 29, 2007 1:45 PM To: [email protected] Subject: Re: [ms_access] History of Changes I usually accomplish this task by using FiledName.OldValue in the BeforeUpdate event of the record. I then get the date, CurrentUser and the new value and use SQL statement to add these values to an audit trail table. All this in VBA. HTH Liveson ----- Original Message ----- From: sandynielsen60187 To: [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com Sent: Wednesday, 28 November, 2007 9:52 PM Subject: [ms_access] History of Changes Is there a way that Access can display when a change was made to a field. My client uses TA's (it's a college environment) to enter data and needs to be able to recognize what fields the TA changed and when. Any thoughts or possibilities? Thanks in advance. Sandy Nielsen [Non-text portions of this message have been removed] CONFIDENTIALITY CAUTION: This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. PT Darma Henwa does not accept liability for damage caused by this email and may monitor email traffic. [Non-text portions of this message have been removed]
