Track Changes to Field-history table almost complete

S

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

History table 15
CurrentUser to update into table field 2
Access Daily Entry with multiple entries per field 0
track changes to data 1
Copy Field to another field in different Table 1
main form based on table with no date field-need to tie-Sun dt w/s 2
calculated field in form - to table 2
Passing the CurrentUser to a field in a table 2

Top