How to set query parameters from VBA

[amorphous999]

I am running Access 2002. I have some reports I would like to be able to
run from VBA or interactively. The reports use queries with parameters.
When the user runs the report, the parameter prompts for the query are
displayed, and the user fills them in. What I would like to do is set
those parameter values from VBA when running the reports. Is there a way
to do that?

Thanks in advance,

amorphous

[pietlinden]

I would think it would be easier to remove the parameters from the
queries you're using and then just pass a valid Where clause in the
open event of the report. Then you can build whatever filters you want
and reuse the report more easily. bit that's just my opinion.

[Tom van Stiphout]

On 16 Aug 2006 03:16:56 GMT, amorphous999 <jf**********@MAPSON.com>
wrote:

Not entirely sure what you mean, but I have been experimenting with
Criteria forms launched as Modal forms in the Report_Open event; just
in time for setting Me.RecordSource.

-Tom.

>I am running Access 2002. I have some reports I would like to be able to
run from VBA or interactively. The reports use queries with parameters.
When the user runs the report, the parameter prompts for the query are
displayed, and the user fills them in. What I would like to do is set
those parameter values from VBA when running the reports. Is there a way
to do that?

Thanks in advance,

amorphous

[Mike Gramelspacher]

In article <Xn**********************************@216.165.192. 91>,
jf**********@MAPSON.com says...

I am running Access 2002. I have some reports I would like to be able to
run from VBA or interactively. The reports use queries with parameters.
When the user runs the report, the parameter prompts for the query are
displayed, and the user fills them in. What I would like to do is set
those parameter values from VBA when running the reports. Is there a way
to do that?

Thanks in advance,

amorphous

You might google groups for: Ken Sheridan parameter query every report

It may be of some help.

[amorphous999]

pi********@hotmail.com wrote in news:1155700842.369166.142880
@m73g2000cwd.googlegroups.com:

I would think it would be easier to remove the parameters from the
queries you're using and then just pass a valid Where clause in the
open event of the report. Then you can build whatever filters you want
and reuse the report more easily. bit that's just my opinion.

basically, i can't do that. the problem is that the report pulls and
groups data from two sources using 2 different queries (call them Qry1 and
Qry2). A third query QryR, joins the results of Qry1 and Qry2 together and
is the recordsource of the report. The filtering criteria I currently
specify in the parameters has to be applied to Qry1 and Qry2 rather than
QryR. That's why I'd like to set query parameters from VBA code.

amorphous