Automating reports containing parameters

[Carol]

I am trying to write some code to automate the output reports from my
database. Some of the reports have parameters to determine the report
content. How do I write code to tell the model what the parameters should be
when the reports are run? I am using the DoCmd.OpenReport function but do not
know how to tell it what the parameter value should be for a specific report

 

[Damian S]

Hi Carol,

Is it practical to have your query (that is prompting you for the
parameters) to pick the param's up from a form? That's a good way of not
being prompted...

Damian.