Unbound Combobox search issue

[Eliza P]

I have a small employee database (200 employees) It has phone, department and supevisor information as well as a bitmap picture of the employee. I use a form with unbound combo boxes to enable others to search by first name or last name to view the particular employee information. The combo boxes work independently.

It works fine except when there is more than one person with the same first or last names.

For example if two employees both have the first name Janet, I cannot get to the second employee. Typing the last name only may correct it, if there are not two people with the same last name as the second Janet. (which is a factor in our database)

I am looking for help on how to correct this.

[June7]

You could have the two comboboxes concatenate the name parts.

SELECT EmpID, LastName & ", " & FirstName AS EmpName FROM Employees;

SELECT EmpID, FirstName & " " LastName AS EmpName FROM Employees;

Other combobox properties:

BoundColumn:1
ColumnCount: 2
ColumnWidths: 0";2.0"

Users will see the names but then code could use the EmpID for search.