Subreport problem.

H

Hallgeir

I start with a blank report. I drag two simple indvidual reports onto the
blank report. There is no link between the individual reports, but i have
the same parameter in both the queries that the individual reports is based
on.

My new report containing the two subreports work just fine, but access
prompts for the parameter twice. Does anyone know if there is an easy way to
get access to prompt me only once when I run the report.?

thanks
Hallgeir
 
F

Fons Ponsioen

The simplest way I find is to create a form with one or
more textbox(es) where I enter the the parameter such as a
date or an other variable, than I set the criteria in the
report query to the form textbox i.e.,
Forms![Print Dialog]![TexboxName]
Hope this helps.
Fons
 
H

Hallgeir

Fons Ponsioen said:
The simplest way I find is to create a form with one or
more textbox(es) where I enter the the parameter such as a
date or an other variable, than I set the criteria in the
report query to the form textbox i.e.,
Forms![Print Dialog]![TexboxName]
Hope this helps.
Fons
Click to expand...

Thank you!
This solves my problem.

Hallgeir
 
Top