>I have a form the I use a pageframe with 5 pages, page 4 has a data grid, all the other pages have text or edit boxes on them. The data enviroment consists of about 4 main tables. The problem I am haveing is the speed at which the form loads. It takes about 2 minutes to load the screen. When I give it a specific file to find, the weird thing is if I do not tell it to limit the file to a specific number the form loads in 6 seconds with 10 times the amount of data in the limited form. I have tried everything I can think of. Any ideas????
>
Rich,
How are you limiting the data? Are you using filters? These are extremely slow, even optimized, when used in a grid. If filters, can you change the grid to use a view. This may speed things up.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao