Combo box slow to populate

[Sasha]

I have a table with over 500,000 records. I also have a form with a combo
box on it which shows customer names. The combo box takes a long time to
populate. This is a single mdb, and I'm accessing via the network, where
others can use the mdb. How can I speed up the populating of the combo box.
It's really slow.

Thanks,
Sasha

(
)
c[]

 

[Graham Mandeno]

Hi Sasha

No user is going to want to scroll through half a million rows in a combo
box to find a customer. I suggest instead you provide a textbox in which to
enter the first 3 or 4 characters of the name, and populate a list or combo
box using the partial name as a filter.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

 

[Sasha]

Using a text box is not an option. I need to speed up the existing combo box
when the user begans to typr in a customers name. Any ideas on speeding up
the existing combo box.


Sasha