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.
|
Similar Threads
