combo list on request

[lez]

Hi Guys,

Does anyone know of a way to only pouplate a combo box with values when a
letter is entered into the combo box?

Lets say you have a combo box for all the countries in the world for a user
to select, rather than list all countries, I would like when the user enters
the letters for his country of choice then only countries with these listed
would show:

ie. user is looking for United Kingdom, enters 'U'

countries listed
United Kingdom
United States
Uganda.....etc
Any ideas or altenatives would be helpful.

Regards
Lez

 

[golfinray]

Allen Browne has a type completion at www.allenbrowne.com

 

[Ken Snell [MVP]]

I have a sample database that uses a textbox and combobox in combination to
do what you seek:

Text Box & Combo Box Combination
http://www.accessmvp.com/KDSnell/SampleDBs.htm#CombinedTextComboBoxes