how do i create a log of updates in access 2003

[Guest]

I am trying to create a log of updates applied to a record that would appear
in a memo/text box. How do i create a log of these updates, it must contain
the time, username and the action. Any help would be appreciated.

 

[pietlinden]

There's code for all this and explanations at Allen Browne's website.
www.allenbrowne.com I think it's under AuditLog or something like that.

 

[Allen Browne]

See:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

The article explains how to use the events of the form to create a copy of
the record when it is created, edited (before and after), or deleted, with
user name and date/time.

You will need some understanding of VBA to implement this.