Track Changes to Field-history table almost complete

[sherryberrygentry]

Hi,

I have a form that links directly to my master table. I have two
fields that I need to track/document when they were changed and the
keep the old value. For example, if the car goes for sale on 8/19,
then sold on 8/20, I want to see that history.

Something like this:
Date Time Currentuser Status ContactID
8/19 11:30am sbge For Sale 1
8/20 11:15am sbge Sold 1


Should I created a separate table and subform to the main form. I have
the time/date, currentuser stamps working, but the field is always set
to the current value of the main form its not tracking the old value
and the updated value.

Any ideas?

Many thanks,
SB

 

[Svetlana]

You must add a field autonumber that will be your primary key (unique)
as like HistoryID to your table or you could make a table with fields
like
ContactID Currentuser DateForSale TimeForSale DateSold TimeSold