I need HELP building tracking report

[chubby]

Is there anyway to build a report in which it tracks when updates occurred to a number of records???

For example, say I have a database that contains 400 personnel records with 20 fields each. My user updates the home phone numbers of records 100 thur 105 on Jan 9, 2002 tthey also added the birthday dates to 3 personnel on Jan 10, 2002. Is there anyway to track by date when these records were changed, then place that information in some type of report stating that? Example:

RECORDS THAT HAVE BEEN UPDATED
Personnel record 100 updated on Jan 9, 2002
Personnel record 101 updated on Jan 9, 2002
Personnel record 102 updated on Jan 9, 2002
Personnel record 103 updated on Jan 9, 2002
Personnel record 104 updated on Jan 9, 2002
Personnel record 105 updated on Jan 9, 2002
Personnel record 103 updated on Jan 10, 2002
Personnel record 105 updated on Jan 10, 2002
Personnel record 300 updated on Jan 10, 2002

Note: I don't want to know what changes were made, just that they were changed on the date of the changes.

Thanks X-)

 

[JerryDennison]

The answer is yes and no. Yes, you can use code to add records to a table for tracking changes made to another table (exactly as you described). No, because this can be circumvented if changes are made at the table level (bypassing your form).

Create a table to capture the change records. This table could be as simple as three fields, EmployeeID, Date, ChangeID. In the AfterUpdate event of the data entry form use code to test for whether or not this was a new record, if not then add a record to the change tracking table passing the EmployeeID (if you setup the default date to Now() at the table level you won't have to do anything but append a new record with the EmployeeID)