Paul ---

Perhaps you could try opening the views before instancing the forms? This would give an apparent speed increase....or, get rid of the DE (if you are using one) and open the views in Form Load.


>No, the rowsource for my grids are views and I am using NoDataOnLoad set to True. I have textboxes on the first tab of a pageframe that are bound to a table but that table only has 20,000 records. I have 2 views one based on each of the very large tables.
>
>>Hmmmm.......Do you have any grids, listboxs, or comboboxes where the rowsource is one of the big tables? That could be the slowdown. You could use views with NoDataOnLoad set to True, and then selectively requery.
>>
>>>I have noticed that my form's instantiation speed is determined by the size of the files in the data environment.
>>>
>>>I have a form that has a table with 350,000 records and another table with about 200,000 records. When I issue the do form it takes 15 seconds for the form to load. If I zap these tables then it takes about 4 seconds.
>>>
>>>What is happening here? Is there some setting I can set to speed this up. I don't think my customer's are going to find this acceptable.
>>>
>>>Thanks,
>>>Paul