Postpone subform query in tabbed control

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?
 
G

Guest

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

subform record source tabbed page 2
Setfocus on subform on tabbed form 3
return Subform Name on Tab control 1
Tabbed form help 1
Help With a Query Pop Up 4
Same subform in multiple tabs of tabbed control ??? 1
After update find record on subform 5
Tabbed control and populating multiple subforms 7

Top