Slow subform (1 Viewer)

I have a form with a subform (there is no child parent relationship) , when I open the mainform it causes the subform to slow down.

ie If I open the suform by itself - it opens quickly
If I then open the main - it runs quickly

If I then open the main again it runs slow or if I open the subform again - it runs slow - it continues to run slow - until I have opened the sunform by itself.

So something in the mainform is causing the subform to slow down.

Help! Thanks

Paul,

Need more info ...

Does the main form ReQuery the subform?

Do you have any timer events?

Wayne

Hi Wayne - I think I may have solved this - the main form was changing the recordsource of the subform, it seems that the subform had to learn how to execute the recordsource again - it seems to be solved by having the form initially unbound.

If you can throw any further light on this please do.

Paul