save oldvalues in new record

[David]

I would like to create a new record in a table of log records, when any field
in a form in Access 2003 built with fields from multiple tables is updated.
This new record would be a snapshot of the fields used in the form and would
not necessarily need any relationship with any other table.
I have used the expression builder exclusively before and have little to no
experience with event proceedures and macros.
I want to capture the current date, DVR ID#(primary key), HD ID#(primary
key), Bus#(primary key), and Activity (text field) to create an ongoing
activity log.

I know you will not code this for me, but will you give me an idea of how to
accomplish this?

 

[Piet Linden]

I hate to burst anyone's bubble, but building a audit trail isn't easy and
isn't going to be done using the Expression Builder! It is going to require
code and a fair amount of code at that. But a gentleman by the name of Allen
Browne has an excellent article that explains exactly how to do this:

http://allenbrowne.com/AppAudit.html

That's one of the nice things about SQL Server... you can do it with
the INSERTED and DELETED tables... and it's free... One of the VERY
few times I actually agree with Aaron Kempf.

 

[David]

Thank you for your reply.
I DO understand "expression builder" cannot do this and further understand
code is probably necessary, but I do not understand the website you referred
me to. Basically I want to save four fields from a form to a new record on a
separate table. The website seems to be trying to accomplish far more
comprehensive logging.