how to display names in Combo Box as you type...

[spdy32]

Need help in making a combo box in a form linked in a table with several columns. My main concern is given that I have 3 columns in the table namely First Name, Middle Name, Last Name, If I am in the form I want to call the information of a particular person, the step is I will type say C it will display all Last Names Starting in C together with the First Name and Middle Name. Example Carey, Jim Newman. And it will narrow down to a specific person as I type A particular name.

[Stewart Ross]

Combo boxes in Access already have this facility (autocomplete). To make this work with names you feed the combo box from a query which concatenates the name fields together. If I assume there is a key field which will remain hidden in your combo box (so you can write code to go to the record concerned after the combo is updated) the SQL for the combo would be along the lines of:

SELECT
       [Your Key Field],
       [Last Name] & ", " & [First Name] & " " & [Middle Name] as Name
FROM
       [Your Table]
 
ORDER BY
       [Last Name] & ", " & [First Name] & " " & [Middle Name];
 

-Stewart