Have a Search form to lookup in an Employee table based on Emp #, or Name, or
SSN. When search is executed with one of the above, the information is
Suppose..... search is done by Emp #, name and SSN is returned. If SSN is
incorrect and then corrected, another entry is added to the Employee table
for the same Emp #. The results are two entries for the Emp # and Name with
the correct SSN and the incorrect SSN.
What can I do where the correcting information overwrites the wrong and only
have one for the employee. Using a dlookup to search the table.
Thank you in advance for any assistance you can give.