>>Obviously, buffering is not suspect anymore, so you may look at Select-SQL >Rushmore. Also, do you provide select into different cursor alias running the >second form, or you use private DS?
>
>The form has a dropdown list that uses a select into a cursor on a different table and since the form is run more then once they're both identical. I tried running as a private data session and not and the effect was the same, the first instance of the form ran fine.... the second was very slow.
>
>Don
How many records you retrieve into the cursor. If the number is big enough, let say more than 250, then list can be really slow and you better use grid.
Edward Pikman
Independent Consultant