>>>I have a pageframe control with 8 pages, 3 of which have a grid, the others just have text fields...
>>>Ever since I have added the grids to the 7th and 8th pages, the loading time for the form/pageframe has been dirt slow... any suggestions would be greatly appreciated....
>>>
>>>sc
>>
>>Might be something with grid.recordsource. Try to clean it (for test only) and see what happen.
>
>well what I'm doing for these particular grids is using a SELECT-SQL for the appropriate criteria into a cursor and setting the RECORDSOURCE for the grid to the cursor....but I can't believe that it would take as long as it is..
It depends on SQL-Select quality. So, you may first make the abovementioned test, and if recordsource is really the reason, post this SELECT here for UT consideration.
Edward Pikman
Independent Consultant