LIKE function help needed in combobox in the form

[naveen prasad]

i have a table t1,

fields names,age,place

in form , a combo box c1 added and in its properties
row source type is table/query
row source "select distinct t1.place from t1 order by place;"

auto expand yes.

now in combo box key down properties

c1.drop down

now distinct places can be seen in combo box
now i want to add like function to the combo box ,

so that i can see matching places drop down list of current typed text in
the combo box.

example if i type ae in the combo box

it should displays all the possible places which contains the "ae" as drop
down list

pls advice how can i get it...

 

[Stefan_889_12]

Hello Naveen,

please set AutoExpand Property to Yes in Data tab of your combo box.

Stefan.

 

[naveen prasad]

dear i have made it already....

i dont have any problem with normal drop down list , but i want to add LIKE
function and my problem is how can i do it as i explained below....

 

[Ken Snell]

You cannot do this directly in a combo box. You would need to use a
prefiltering setup of some type to do this.

I have an example database that shows how this can be done using a
combination of a textbox and combobox; note that it's using a class module
in the code, so it may be a bit unclear to any novice ACCESS users.

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


There are other examples of using prefilters as well:

Arvin Meyer (MVP) has some sample databases that you can download for
another approach. See ExpandingSearch97 and ExpandingSearch2K at
http://www.datastrat.com/Download2.html

Allen Browne (MVP) has another approach at his website:
http://members.iinet.net.au/~allenbrowne/ser-32.html