Supplying param to subquery for report

R

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?
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Distinct subquery in a Report Control? 1
Opening a form invisible 1
Command button does not pick the correct report. 7
referencing form control in a report 2
subquery without using EXISTS word (?) 1
Function in Control Source with Param 3
filrter several reports 2
Is Null in a Report 2

Top