form with tab control takes a long time to open

hey guys i've got a form with a tab control containing a few subforms. it takes very long to open because i think it's opening all the queries the first time it's open. i've attached the database here (though it's missing some of the queries), how do i ensure that Access doesn't make the user wait whilst they open forms that the user doesn't see because it's not in the visible tab right now?

i've already got code to sense for the active tab and refresh just that subform but upon opening the form for the first time, it seems that it's mandatory to open all the queries once - i couldn't intercept the events - or rather don't know how to ha.

thanks guys!!!
Query.mdb