how to keep old record into tblHistory or archive table?

K

Kurosagi85

i need help and its urgent...

i have created a table with fields: ItemNo, ItemName, IncomingStocks
and also DateReceived.

The IncomingStocks and Date Received are volatile. it is expected to
change several times during the life of a record

Data is being entered via a form. I want to create a so called HISTORY
or ARCHIVE table that receives an insert when the record is updated
showing the record as it appears BEFORE the update. My goal is to
maintain a 'History' of each record

I have tried the simple append query

but it keep on copying the whole records instead of the 'ONE' record
that i change..

can u guys please help me....

tx
 
Top