Query running multiple times

[Dida]

Hi,


I created multiple forms where one contains a query. I decided to create another form to create a tab control which contains sub forms(including the one with the query). When I change the view to form view, the query is generated 2 times. Is it because it's running one for the first form and the second query is related to the second form which contains the sub form? If that's the case, what should I do?

Thank you.

[June7]

Not sure what you mean by 'contains a query' and 'generated'. Is this query the RecordSource for a form? If this is not a SELECT query but some other type, then what?