search criteria for a list bos

[Camon]

I am creating a list box for users to be able to lookup information in one list box that is unique and display all entries in the list box next to it. That works great exept there are more uniques then I first thought and the users are only able to select the first key to shorten the search. I was wondering if anyone knew a way to let access accept more then one key for a search in a list box. without having to go with a seperate field to enter data for the search.

Any help would be greatly appreciated thanks.

 

[Pat Hartman]

I use this technique to allow users to select sales people from a combobox.

Select RMID, Trim(LastName) & ", " & FirstName AS FullName
From tblRM
Order by Trim(LastName) & ", " & FirstName;

The RMID is the bound column and FullName is what is displayed in the combobox.

 

[Camon]

Hello,
Yah that will work to use the box but im curious how can you let the user look up a last name for instance by type smith on the keyboard in a list box. Instead of only being able to type 's' then scroll down to smith. Thanks again