Access does not provide this for you, but if all changes are made through
forms, you can use the events of the form to record edits, deletions and
inserts.
Details in:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"musicloverlch" <lh****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I'm looking for an simple bit of code that I can put on any field in a
form to record any changes. Not only do I need to know who changed the
field, but also what the original value was.
Is that possible?
Any examples available?