>>>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..
Try running the SQL in the command window to see how long it takes to return the results. Also, analyze your SQL to make sure it's as optimized as possible.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.