Slow Forms Opening Part II

[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

 

[gandalf]

some general performance hints:
http://www.granite.ab.ca/access/performancefaq.htm

What Access Version are you using?

 

[Burt Rosner]

Gandalf,

Thanks. I'm going to look at it now.

Burt