Populate ComboBox on Form Load

[mohsinhq]

i need to populate a combobox on form load as it holds a lot of records.

the problem is that when the user clicks the combobox to select a record it takes too long to populate the combo with values.

any help appreciated..

 

[Mile-O]

The combobox does load your records into the combo as the form loads (if you have the query set as its RowSource). It just doesn't load them all in until you start playing with the combobox. Even then it only loads them in as needed.

 

[mohsinhq]

is there a way to pre load all the records even before you start playing with the combo box?

my users are quite impatient people!

i dont want the user to be waiting for all the records to load in the combo box but for the combobox to be ready to be selected.

 

[Mile-O]

Is there any way you can break the query that feeds the combobox down in order to speed things up?

i.e. a cascade or a frame with options(a, b, c, d, e, etc. ) which queries accordingly. The less records the quicker - that's the rule.

You won't be able to load all the records in at one time - if your query exceeds (I think it's around) 65,000 records then that's the maximum you can load in at all.

Try looking at some of these tips or consider a cascade of some description.