Execute query only when tab (subform is active)

[Sniper-BoOyA-]

Good Morning,

As you may remember, i am having some problems with a graph on a subform. After a couple of days of trying several 'solutions' i tried to make a input criteria where the user can enter a ProctorID, which filters the graph and shows the graph of the given proctor.

Which works great.

But heres the thing, everytime i open the 'Motherform' it also executes all the queries, and yes, it also asks for a proctorID.

Is there a way to only execute a query when the tab (subform) of the graph is active?

Cheers in Advance!

 

[JANR]

If you Latebind the graph subform like Oncle Gizmo suggested here: http://www.access-programmers.co.uk/forums/showthread.php?t=199234

It should solve your problem, use the click event on your tab to load your subform's recordsource. Remember subform load before your mainform, it might also improve the load time of your motherform

JR

 

[Sniper-BoOyA-]

Thanks m8.

Problem solved with a simple

Private Sub Form_Load()
Me.Form.Tabsubforms.subformprctrgrfkNEN.RecordSource = queryproctwtrgehgrfkNEN
End Sub

Cheers