>>>>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.
I don't believe it's a RECORDSOURCE problem.. I cleared out RECORDSOURCE ..loaded..same amount of time..any other suggestions?
Sean Campbell
www.upstagesoftware.comsc@upstagesoftware.com**********************************************************
Eddie, I wouldn't be anymore surprised, if tomorrow I woke up with my face stapled to the living room carpet.
Clark W. Griswold
**********************************************************