Slow Form Opening

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.

Any help would be appreciated.

Thank you in advance,

Burt
 
Top