By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

How to track the history of a selected number of fields in a record? Access2003

P: n/a
I have set up two tables ****current and ****history.

The history table contains all the fields which I want to track changes
on. The current table contains just the most recent information from
those fields (history not important).

The entry forms are set up with a query to access each field from it's
correct table. I have a 2 field primary key in the history table
(field 1 is a facility ID, and field 2 is the date of inspection). In
tracking the history the facilty ID will be duplicated, and the date
will also be duplicated for different records, but not both at the same
time (so I believed this to be the best way to go).

The problem I'm having is when I open the form it brings in the most
recent information from both tables, but when I go to save the record
(the facility ID is the same, but the date is different)it just
overwrites everything in the history table and doesn't create a new
record under the different date there.
Any suggestions would be appreciated. Thanks.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Read this article...
http://www.mvps.org/access/modules/mdl0021.htm

or just download the code and play with it... of course, you gotta lock
the users out of the tables...

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.