Audit trail

[Guest]

I found an Article on creating an audit trail of record changes in a form in
Access 2000, Microsoft article ID 197592. It works well except for the fact
that it also tracks the fields that haven't been updated. Is there anyway
that I can get it to ignore those fields and only record the ones that have
actually changed.
Thanks

 

[Joan Wild]

Have a look at Allen Browne's site...
http://www.allenbrowne.com/AppAudit.html

 

[Guest]

Thanks Bob:
I tried the 1 from rogersaccesslibrary.com and it worked like a charm.
However I do have 1 question. It is set up to work on text boxes and 1 field
on my form is a combo box. Any Suggestions on how to modify it to work with
the combo box also.
Other then that it records everything else that is changed or deleted from
the form.
Once again many thanks.

 

[Guest]

Thanks Bob:
Once again things worked well. You guys are so helpful and patient , I
really appreciate it.
Thanks