>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.

Shihchau,

Make sure you have an index on Inventmst on DELETED(). That is about the only thing I can see other than the ORDER BY that would slow this down. Another alternative would be to put Inventmst in the Dataenvironment of the form and set its order to Stkcode, then make the combo's rowsource type Fields and the rowsource Inventmst.stkcode, this would be faster because you are not doing an SQL select with an ORDER BY in it.