locating records in Combo Boxes

G

Guest

I have the following fields in my Employee ID combo Box: employeeID,Last
Name, First Name,Mid,Office

I Have "hidden" the EmployeeID column so when the user starts typing, the
box begins searching by Letters in the Last Name; however given the number of
employees, there are many last names that are the same. I want to give the
user the ability to further type letters in the FIRST name to help filter the
list. Can I do this? Do I need to Combo boxes?

Thanks so much.
 
A

Allen Browne

You already have a combo where the Column Count is 2, and the Column Widths
is 0.

Set its RowSource to something like this:

SELECT EmployeeID, [Last Name] & ", " & [First Name] AS FullName
FROM Employees ORDER BY [Last Name], [First Name]
 
G

Guest

Thanks so much! Works great
--
Lele


Allen Browne said:
You already have a combo where the Column Count is 2, and the Column Widths
is 0.

Set its RowSource to something like this:

SELECT EmployeeID, [Last Name] & ", " & [First Name] AS FullName
FROM Employees ORDER BY [Last Name], [First Name]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Lele said:
I have the following fields in my Employee ID combo Box: employeeID,Last
Name, First Name,Mid,Office

I Have "hidden" the EmployeeID column so when the user starts typing, the
box begins searching by Letters in the Last Name; however given the number
of
employees, there are many last names that are the same. I want to give the
user the ability to further type letters in the FIRST name to help filter
the
list. Can I do this? Do I need to Combo boxes?

Thanks so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top