Open form with subform No Update

[insane53]

Hello Good day,

i have built a form, with a field called ID and four subforms, each on its own page, each of which display a query based on ID. As it is now, when i open the form, it runs the 4 queries with the empty field, then when i update the ID field in the main form, all 4 queries run.
What i want is 1) to open the form with no queries running, giving chance to insert an ID in the main form
2) for each query to run only when its page is selected.

Thanks in advance for any help and apoligies for any forum noob mistakes.

[June7]

1) You want to open form to a new record? You can either set the form DataEntry property to Yes, in which case it will always open to new record and never show existing records. Or you can control this with code. I use only VBA:
DoCmd.OpenForm "formname", , , acFormAdd

2) The Master/Child links of subform container controls synchronization with main form. Since subforms have a recordsource they will populate accordingly. Controlling the RecordSource or the links properties not practical. Could easily control visibility of the subform container.