Supplying param to subquery for report

[RanceR]

I wasn't sure whether to put this in Reports or Queries.

I have a rather complicated set of queries I am using for
a report. The first query (subquery) that must run takes a
parameter, but I don't want to specify a particular
form/control to supply the param because the query will be
used for other reports and as a subquery for other
queries.

To open the report I am using:
DoCmd.OpenReport "rptMyReport", acViewPreview

How can I supply the parameter to the subquery and open
the resulting report?

 

[Duane Hookom]

You can open a form invisible and set the control value. Then open the
report.