>>OK, I've banged my head on the wall enough on this.
>>
>>I have two pages in a pageframe with some textboxes to enter search criteria on Page1 and the results being displayed in a grid on Page2. Whenever I enter search criteria and execute the search the first time the data appears in the grid control correctly. Because the results return a cursor with a lot of records the scrollbar is active and the scrollbox displays. However, if I click back on the first tab and re-execute the same query and return the same cursor, the scrollbar is disabled and the scrollbox disappears.
>>
>>And yes I do make sure I've set the RecordSource back to a dummy SQL statement before re-executing the query so that I don't lose all the settings on my grid.
>>
>>Anyone have an idea about this one? I haven't found anything on this when I searched the forum. I'm running VFP8 on Windows XP.
>
>If you reopen the recordsource alias (by re-executing the SQL, that counts too), you lose the grid. It rebuilds. Search for "safe select" - it's been discussed at lengths.
>
>Basically, you have a cursor for the grid, which doesn't close for the lifetime of the grid. You zap it and insert into it as needed.


Hmmmmm, interesting approach, Dragan. I'll give it a shot.

Thanks,
Ken