Load combo box data faster?

[ghudson]

Is there a trick to making a combo box load it's data value any faster? I have a combo box that contains a lot of values to select from and the user must slowly scroll down until they reach the end if they are visually searching. I need to load all of these values so limiting the data source is not an option. I thought I had seen some where way back a posting about counting your combo box data or something like that to make all of the values load before the user first clicks the combos scroll bar.

Thanks in advance for your help!

 

[dcx693]

Yes, you can make combo boxes load all their data all at once if you count the number of items in the combo box.

Enter code like this into your Form's Load event:
Dim lngCount as Long
lngCount=cboBox.ListCount

Note that this will slow down the loading of the form containing the combo box.

 

[ghudson]

dcx693,

Thank you!!!! That was exactly what I was looking for!!!

Form opening speed was not affected and the combo box has almost 3,000 records.