Combo box and entering data

[jayderk]

I have a combo box of customers.
the problem: they can have 10000 customers in the list and that is terrible
programming to have the combobox object hold that many items.

does anyone have any suggestions on how to make a search criteria for this?

for example when you start entering a address in Internet explorer, it
'filters' it so eventually you can select one of 20.?

any assistance would be greatly appreciated.


regards,
Jay

 

[Peter Foot [MVP]]

How about a control which lets the users select from groups of letters, a-c,
d-f etc and the only load the required subset. Or using a textbox allow the
user to enter a few letters and search for a partial match using the 'LIKE'
SQL operator or similar.

Peter

 

[Alex Furman]

If it is possible to group customers you can use a tree control. I usually
save each group in a separate file and load it on demand into the tree
control.

 

[garfitz]

Or categorise via a treeview control...

How about a control which lets the users select from groups of letters, a-c,
d-f etc and the only load the required subset. Or using a textbox allow the
user to enter a few letters and search for a partial match using the 'LIKE'
SQL operator or similar.

Peter

--
Peter Foot
Windows Embedded MVP
OpenNETCF.org Senior Advisor
www.inthehand.com | www.opennetcf.org