Updating after a Search

[Guest]

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
returned.

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.

nofluffprincess

 

[Guest]

From the Search Results form, open an edit form that is based on a record
from the search results.

Docmd.OpenForm "dlgEmpEdit" , where:="EmpID=" & me!txtEmpID