>>>>>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?
Assuming SQL is at its best :
Is debugger active ?
Are there any columns using activerow as a controlsource ?
Is there a call to lockscreen ?
Cetin