List box / Combo box to match input

[Tom Knapp via AccessMonster.com]

I would like to include a drop down list on a form just like the help index
box in the help menu of windows programs. I need to have accurate input of
addresses, and though I cant guarantee that the street number will be input
corectly, (I cant list every address) Im hoping to at least get the street
spelled right. Id like to be able to type into the box and have the list of
streets update to match what is typed in. The box also must accept the input
if the street is not in the list.

What is the best way to do this?

Thanks in advance.

Tom

 

[MacDermott]

You'll need to store your street in a separate field from the street number.
You can then base your combobox on a query like this:
SELECT DISTINCT [Street] FROM [MyTable]
Use your own names for the [Street] field and the [MyTable] table.
If you want to accept items not in the list without question, be sure its
LimitToList property is set to False.

HTH