hi all,

i have a small problem about to apply filter in a combo box and requiry records.

i am using a combo box named InstituteName which contains names of all institutes (approx 60,000) from a master table "Institutes".

i have set combo box InstituteName auto expand property to YES.

problem : i want to shrink list automatically as i type text in the combo box

exa : if i start typing with J then only records which contains J, must be in that combo box rather than all records, then if i press next character A -> now it must contain only records containg JA and so on so if finally i type JAIPUR, it must contains only records which contains JAIPUR in it.
(JAIPUR could be anywhere in records, starting, middle, or anywhere in records)

i have no idea from where to start, and how to do it, if anyone can help i will be very thankful. i am still searching its solutions so all suggestions are welcome.

thanks for reading this problem and considering it

thanks once again

ashok sharma

You can do this with code, but I am not sure if you have enough events to dynamically shrink the combo box this way.

Also, it looks like your code will do this:

Type "J"
Search for all records with J anywhere in string.
Type "JA"
Search for all records with JA anywhere in string
Type "JAI"
Search for all records with JAI anywhere in string
etc

I would suggest giving the user a text box where they can type in "JAIPUR" and then have THAT return a combo box populated with all strings with "JAIPUR" in them.

Would that work for you?


mmcdonal

Hi

thanks for your reply and considering this problem.

if you can plz guide me just from where to start ( or what route to follow) am sure i can do it.

thanks once again

ashok sharma

Hi,

Allen Browne has a neat solution to this problem in his list of tips. You will find it here: http://allenbrowne.com/ser-32.html

I hope you find it useful.
Hunter57