Added a sub-report but have to enter parameter twice

[Tracy]

I amcreating an invoice. To create the invoice, I must
pull the tax information from a sub report. When I added
the sub report I made the invoice header the link between
the two reports. Now when I run the main report, I have
to enter the invoice number twice, as the parameter window
comes up twice. The report runs fine, why is it doing
that?

Thanks in advance.

Tracy

 

[Duane Hookom]

If both reports depend on a parameter query, you will get prompted once for
the main report and once for every instance of the subreport. If this is
your situation, you may want to pull the parameter value/criteria from a
form control. Your criteria would then be something like:
Forms!frmA!txtYourCriteria