You can do a few experiments to compare times:

1) In a PRG open all the tables with and without data. What is the time difference? This shouldn't account for much of the time unless you're working on a very slow network.

2) Do you have any combo boxes in your form? What data is shown in them? Is the data from tables, arrays, entered manually? What is the RowSourceType?

3) Do you have any list boxes in your form? What data is shown in them? Is the data from tables, arrays, entered manually? What is the RowSourceType?

4) On your grids is there any calculated data in any column?

5) Do you have any SQL-SELECT commands anywhere? If so test them in a PRG to see how long they are taking. Use Sys(3054) to test optimization.

6) Add "wait windows" to the code at the beginning and end of the LOAD() and INIT() methods. You may see where the longest time is spent. Then you can test the code in the method that's taking the most time. If the longest time is between the end of Load() and the beginning of Init() then the problem is linked to one or more of the controls on the form.

These tests might show you where the time is going.

HTH
Barbara


>I had posted the similar question before, But I still can't solve my problem
>
>I got several forms, which got 5pages frames,
>the no.of textbox over 50 , there are 2 grids,
>
>In the data environement , I put around 22 tables,
>1 is company tables, which got over 3000 thousand records.
>around 7 tables got over 1000-4000 records.
>
>Now , as I load the run from the menu bar,
>It spends the time over 30-40 seconds.
>
>IF there is no records in all tables.(except the company, currency,country) ,
>It spends the time over 5 seconds,
>
>My problem is 'Are There too many object, so that the loading time is too long' ?
>
>Or. My form got too many tables, ? (I got put the tables, No'views')
>
>Any solutions can make the form load much faster ?
>
>Thanks.
>From Agnes