Slow Forms Opening Part II

B

Burt Rosner

To Whomever can help,

I created a Form with a subform. When the Form Opens the
subform performa a query on a table and lists the results.

Problem:
The listing is not very big. Maybe in the hundreds of
records. However it takes anywhere from 4 to 10 seconds
for it to display. When I requery, no problem. Comes
back within a second.

Is there a way of speeding up the opening? Or is there
another way to design tne form to speed up the opening.

To Whomever can help,

I created a Form with a subform. When the Form Opens the
subform performa a query on a table and lists the results.

Problem:
The listing is not very big. Maybe in the hundreds of
records. However it takes anywhere from 4 to 10 seconds
for it to display. When I requery, no problem. Comes
back within a second.

Is there a way of speeding up the opening? Or is there
another way to design tne form to speed up the opening.


Someone mention http://www.tek-tips.com/viewthread.cfm?
qid=206410, but that didn't work for me.

Any other suggestion would be appreciated.

Thank you in advance,

Burt
 
Top