Access 07- Audit Trail

[Swethe]

I am building an inventory database for computers at our company, and
everytime equipment moves locations I would like to have the old
location copied (Set Value) to an Audit table along with the serial
number (key field) and date moved, before updating the record, my
bosses want to see where the computer has been and we do not want to
leave it up to human error to rember to copy the data to the audit
table. I have a form and I am having problems with the SetTempVar
action in a macro, don't know what to put in the expression area.


Thanks in advance.

 

[June7 via AccessMonster.com]

Did you look at Help or the MS knowledge base? Here is a link:
http://msdn.microsoft.com/en-us/library/bb177443.aspx

Personally, I don't like or use macros, only VBA code, so I can't be any more
help. Especially since I don't know what the variable is needed for.