I'm currently using a number of comboboxes (AutoExpand = True) as search fields for my database- the user can scroll through the list, or type out the name and it will pull it up. But I wonder; what will happen when there are hundreds of records in each combobox? What if it gets as large, potentially, as thousands? Is this not a serious problem? Or is there a better way?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Type-ahead search in large database
- Thread starter Chad1984
- Start date
missinglinq
Programmer
In the beginning God created...Allen Browne...and it was good!
It seems like no matter what needs being done, Allen has done it! He has a hack that doesn't "AutoExpand" the combobox until three characters have been entered, thus reducing the possibilities when there are a huge number of records to be retrieved! Hope this helps!
The Missinglinq
Richmond, Virginia
There's ALWAYS more than one way to skin a cat!
It seems like no matter what needs being done, Allen has done it! He has a hack that doesn't "AutoExpand" the combobox until three characters have been entered, thus reducing the possibilities when there are a huge number of records to be retrieved! Hope this helps!
The Missinglinq
Richmond, Virginia
There's ALWAYS more than one way to skin a cat!
- Status
Similar threads