I have a database in which survey data is entered twice (by coder A & B). Coder A's Form is linked to a table storing their data. Coder B's form is linked to a table storing their data. In every other way, the forms and data structures are identical.
What I need to do is set up a data validation routine. Once coder A has entered the data into their table - Coder B can enter data into their table. What I want to have happen (by what magic I do not know) is when Coder B enters in data for the second time - (on exit or the like) that data is compared to what Coder A entered. If they match - no problem. If they do not match, and message box pops up warning Coder B that what they entered does not match what Coder A entered. Just a warning - no big show. Just a nag to make sure they enter the data right.
If anyone can figure this out..and explain it for a newbie (sample code WAY welcome) I will be forever grateful!