Dynamically Sorting Combo Box

  • Thread starter Thread starter Tom Knapp via AccessMonster.com
  • Start date Start date
T

Tom Knapp via AccessMonster.com

Hi,
I have a form where I need to enter street names into a combo box. It is
important that the street names be entered with the correct spelling. I do
not want the user to be able to enter (type) the street name in themselfs.
The problem is that the streets are for the whole city. There are several
hundred street names. I dont want the user to have to sort through the drop
down list trying to sort through so many names. Is there a way to have the
drop down sort through the records as the useer types the first few letters
of the street name? Somthing like the Index box in the Help menu of Internet
Explorer. Maybe an easy way to do this? I would like the user to be able to
type a few letters, the combo box would sort as the letters are typed, then
the user would see the street name with the focus on it (in a list box), or
use the dropdown and see the street name with the focus on it, and then the
user could select the name to fill in the text box (combobox).

Is this possible?

Thanks,
Tom
 
Back
Top