Hello,
I'd like to have my data entered twice by two separate people to ensure
accuracy. Is there an easy way to do this sort of double entry in Access?
Thanks,
-JJ
Not easy, but possible: you'ld have two forms. The first form would
enter data into a "scratchpad" table; the second form would use the
BeforeUpdate event of each form control to compare the data being
entered with the data in the scratch table. If they match, write it to
the production table; if they don't, bonk the user.
In practice, with a well designed system (making copious use of
limit-to-list combo boxes or listboxes, field validation, etc.) such
double data entry is often unnecessary. It doesn't catch all the
errors (two clerks can misread the bad handwriting in the same way),
takes WELL more than double the time (counting the time spent
resolving discrepancies), and leads to frustration for the data entry
people. Your call though.
John W. Vinson[MVP]
