Combo Box slow

[Phil]

Hi,

I have a combo box on a form which pulls data from a table
with about 4000 records in it. On the first click on the
dropdown, it takes forever for the box to load. Is there
a way to speed up this operaton? Once the box has loaded
the first time everything is fine.

Thanks,
Phil

 

[MikeC]

Phil,

The below link explains a good solution:

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnacbk02/html/ODC_CookbookChapter8.asp

The solution is about 25% the way down the page starting
at "Combo and list box controls".