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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Subforms in a Tab Control 1
return Subform Name on Tab control 1
loading subforms in tab control 6
subform record source tabbed page 2
disabling the query to run on subforms when opening main form 3
Change record source of subform when click tab 3
Multiple subforms 0
adding and removing subforms from subform controls 4

Back
Top