>>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?
>
>Shihchau,
>
>Can you show us the nature of the data and the type of SQL you are using? It sounds like something is not optimized.
>
>When offering the selection of one out of 6,000 choices I would probably use a search page in a page frame to present a combination of a list and a textbox that allows typing in the textbox and refreshing of the list as the user types. Something like the file opn dialog in windows. This could be done using a pageframe with no tabs and programatically changing the page when the user indicated they want to choose one of the 6,000 itmes.
>
>It is sort of difficult to suggest an alternative without knowing the app and the nature of the data.

My SQL is :
select inventmst.stkcode from inventmst order by stkcode into cursor cstkcode

'stkcode' is a regular key (unique on business rule level).

The combobox is a class used for searching stkcode. As I said, I already have a popup picklist but I want to limit the user to the valid stkcode using the combobox. The 'file open dialog' idea sounds like my picklist where the user can filter and search for stkcode.

If there is no faster or easier way, I probably will change the combobox into a textbox.