If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
LIKE function help needed in combobox in the form
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... |
#2
|
|||
|
|||
LIKE function help needed in combobox in the form
Hello Naveen,
please set AutoExpand Property to Yes in Data tab of your combo box. Stefan. "naveen prasad" wrote: 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... |
#3
|
|||
|
|||
LIKE function help needed in combobox in the form
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.... "Stefan_889_12" wrote: Hello Naveen, please set AutoExpand Property to Yes in Data tab of your combo box. Stefan. "naveen prasad" wrote: 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... |
#4
|
|||
|
|||
LIKE function help needed in combobox in the form
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/Sam...TextComboBoxes 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 -- Ken Snell http://www.accessmvp.com/KDSnell/ "naveen prasad" wrote in message ... 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... |
Thread Tools | |
Display Modes | |
|
|