Getting All Data In Field To Load At Once...

[Goobz]

I have a combo box that has approx. 9,000 records that it is
querying... Sometimes when I select it, they are all loaded and I can
scroll up and down through them with no problem. However, most of the
time when it loads, not all the names have loaded, and I have to hold
my mouse button down on the page down area of the scroll bar, in order
to keep it loading.

Is there a command I can put on the form load that will query or load
all these records before the combo box is selected!?

 

[Pat Hartman]

9,000 is a lot of rows for a combo. I would split it alphabetically. I
don't have any code handy but in the afterUpdate event you can trap the
first letter and change the RowSource to only select records that start with
that letter.