>for my Inovice Form, There are two pages.
>I put the invoiceheader, invoicedetail , company and some other tables on
>the data environment.
>
>From the very beginning. The forms runs fine.
>after 1 years, the invoiceheader got 3,500 records, and the invoicedetail
>gots 25,000. records, the company got over 1,200 records,
>
>as The forms run, it spend over 30 seconds to display the forms.
>
>I know that it is the problem that I load too much data into the data
>environment.
>However, if i didn't do that , (all the textbox is set the control source
>already during design time.).
>
>What solution can make the forms runs much faster.. ??
>Thanks a lot.
>From Agnes

---

Dunno,

But you can open the tables at the start of your app.
You then only have one place where you open tables.
Then the start of your app takes a long time, but when the app is started, it acts quicker.
Also when the user opens the invoice form, closes it, and opens it again you don't have that the opening proces takes that long every time. Now it only takes long to start the app itself.

I alos thought that opening tables manually is faster then with the dataenvironment, but i'm not sure about that. Probably one can test it.