Prevent Subforms from loading when main form is open...

[cariengon]

I'm stuck!! I have a form that takes a long time to open becuase it is running several queries for the subforms on it. I don't need to form to load the subforms & queries supporting those subforms until the user makes a choice as to what vendor they want to see the detail for.

I know there is a way to do this, but I can't find it. Can anyone help?

Thanks,
Carie

 

[gwinn7]

Yeah, don't set the recordsource of the subform until your user needs to view it.

Gary
gwinn7