Board index Office Access

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
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
 
 
 
Top

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
http://www.yqcomputer.com/

 
 
 
Top

1. Windows Search 4.0 update crashes Search function

2. GA-search - genetic algorithms search engine update

3. UPDATE : Help Required to Populate search results - Array Search

4. Printing report b after report a prints using report a's variables

5. Why does Form-A's instance fire Form-B's event??

6. Capture image of App#A's window from App#B

7. using "if" but omitting the #n/a's

8. "Matching" column A's values in column B

9. Formula's with #N/A's

10. Scottie A's Hall of Flame

11. more a's than b's

12. how do u invoke Tag b's Tag Handler from within Tag a's tag Handler?

13. Copy all data from a:Class A's fields to the namesake fields of b:Class B.

14. vlookup prob with all #n/a's

15. Finding the Value (of text and numbers) between N/A's

All times are UTC
Board index