Hi Richard. I am trying to create an Employee Search form where my users can search for an employee by employeeID or LastName & FirstName. I have tried this code: DoCmd.OpenForm "EmployeeF", , , "EmployeeID=" & EmployeeID
and it is not working. What am I doing wrong? It will not let me type in an employee # in the EmployeeID field, and if I type a LastName/FirstName, it creates a new file in the employeeT...

---

Reply from Richard Rost:

If your search form BOUND to your employee table? Make sure there's nothing listed in the form's RECORDSOURCE property. This needs to be an UNBOUND form. The fact that you can't type an ID tells me it's picking up the AutoNumber (which you can't edit) from the underlying table... and if you're getting a new record when you type in a name, that means the data is being saved to the table.