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