>>>I am trying to use a grid to display my results from a select. My WHERE is complex so I understand that it rules out using parameterized views. Currently, I am changing the grid recordsource to "", removing the cursor previously linked to the grid, selecting the records into to a new cursor (reusing the old cursor name), and then changing my recordsource back to the cursor name. The SELECT is executed very fast but when I attempt to repopulate the grid, the less records selected, the slower my results. ( Ex. 650 records < sec., 200 records > sec., 36 records several sec.s)
>
>Cetin, My results from the SELECT is very fast in every instance. There doesn't seem to be a problem, except for loading a grid with the results.
Sorry about misunderstanding.
But maybe this one helps :
Instead of changing recordsource try setting recordsourcetype to SQL statement and recordsource to your SQL.
Cetin