Updating after a Search

Updating after a Search

Post by bm9mbHVmZn » Thu, 20 Sep 2007 08:18:01

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.


Updating after a Search

Post by Uy5DbGFya » Thu, 20 Sep 2007 23:44:04

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

Steve Clark,
Former Access MVP
FMS, Inc