Graphically showing recent changes

[BarkerD]

I've been designing a Production Management system, and one of the important features is that Product specifications changed by data entry persons must be verified before they can be used in the system.

The problem is that changes are constantly being made to product specifications. I need to visually show what changes have been made to a part so that the users who are verifying their accurateness can quickly find the changes.

I have a date field which captures the date and time of the last time the part was verified. I need to be able to change the ForeColor of the fields where changes have been made after this date.

How do I do this without adding code to every field's AfterUpdate Event?

Thanks for any help

[This message has been edited by BarkerD (edited 01-19-2000).]

 

[BarkerD]

SO I create a temporary record for the product specifications. Once the changes are approved, the update can take place. This can work, but there are more complications

1. There are 2 users that need to verify the changes, Production manager and Quality assurance. Both must verifiy the changes before they can take effect. I have 2 checkboxes available for the appropriate users to click. They are part of the table that is in question. Should I make a separate table for the verification?

2. How do I determine which fields have values that have been edited? The users only want to see the changes for easy verification. Could I compare the values from the old record and the edited one, and show which values have changed?

I appreciate your input into this problem.

It's been tough learning Access and VB on the job without any support. College taught me next to nothing