Can I do this with a Combo Box?

[Divit11]

Is it possible to get a combo box control (in Access 2000) to accept a string of characters not on the list and then as a result to run a modified query employing that string of characters and displaying a reduced list from which to make ones selection? Column 1 in the record ID and column 2 would be a CityName. I like the ability to enter a known ID but would also like to search for a small list of cities.

It seems like it should be doable so it someone could lay some keywords on me to point me towards a VBA solution I would be happy to do some further digging.

TIA.

D

 

[edtab]

Set the "Limit To List" property of your combo box to "No".
This will allow you to type in the box anything you want including
something not in the record source of the combo box.

The value that you entered in the combo box can then become
the "criteria" of the query you want to run which in turn can become
the record source of your form, listbox or report for that matter.

 

[Divit11]

Thanks edtab, that sounds like a plan, but I think there are a few steps in between that I still need guidenace on. The ID field is an AutoNumber data type and so I get a error message about value entered is not valid when I try to enter part of a city name.

D

 

[Divit11]

I sure hope this is not one of those "well you can't get there from here" problems.

D