>>If you run with SET DELETED ON and try
>>
>>select pTnt_Name from RegTrans group by 1 INTO CURSOR csr_names NOFILTER ORDER BY ptnt_name
>>
>>would the speed be the same as before?
>
>It took 60 seconds to run the Select this time.
:)))
Ok, as others have said - forget of having that many options in the combobox.
If it's not broken, fix it until it is.
My Blog