>>>>Can anyone offer explanation for slow combo box loading?
>>>>
>>>>I don't know why but sometimes the loading of some combo boxes seems to be very slow.
>>>You are working with VFP3 or VFP5?
>>>How many records do you have to load in combo box?
>>
>>VFP5a SP3. About 6000 records.
>Shihchau,
>
>The time it takes to load the combo is related to how the combo is loaded, is it rowsourcetype alias, or sql? Does it get its data from a view, a table, and array, or is it loaded manually?
>
>BTW, I sure I don't ever have to select from 6,000 options in a combo box. That really isn't the best way to present a user the choice of one out of 6,000 options.

I tried both SQL and ALIAS. SQL seems to be faster but not fast enough.

I agree it is not a good idea to use combo box for anything more than 500. The reason is because I want to limit the choice to those in the list and to allow user to do simple incremental search. In fact I also have a popup search dialog for them.

Any suggestion on what to use? I didn't choose textbox because I need to code to limit their choices. May be I have to use textbox after all?