Postpone subform query in tabbed control

[mscertified]

I have a form containing a tabbed control. One tab in the tab control
contains a subform loaded from a query. As I understand it, every time I page
from row to row on the main form, the query in the subform runs. I dont want
the query to run until the tab is accessed. If I happen to be on the tab, I
do want it to run. Hope this makes sensnse. Is this possible?

 

[SteveM]

Why, what's the problem?

You could use the OnChange event of the tab control, detect which one is
selected and set/unset the recordsource of the subform. I suppose you could
also set the SourceObject of the subform control...

Steve