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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Goobz - 28 Jan 2008 17:55 GMT

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!?

Reply to this Message

Pat Hartman - 28 Jan 2008 18:52 GMT

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.

>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
[quoted text clipped - 5 lines]
> 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!?

Reply to this Message