Stop query tab from opening

[billybeer]

I have a query that shows its results in a subform on the main form. When I run the query the results show in the subform but the query also opens a new tab with the results. I want the results to show only in the subform and not open a tab with the results. How do I do this.

Thanks.

[June7]

Don't run the query.

[billybeer]

How do I get the query results to show in the subform without running the query?

[ssanfu]

Use the query as the record source for the subform.

[June7]

SELECT queries don't have to be 'run' if used as the RecordSource for form or report. Opening the form or report 'runs' the query.

If the query is used directly as the SourceObject of subform/subreport container, again, just open the main form and the subform container and its SourceObject query will 'run'.