Postpone subform query in tabbed control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top