parameter query in sub report

[Guest]

I have parameter that I am using for a reprot and subreport. The creteria for
both reports are the same. Both reports are geenerated from the same query. I
can't seems to get past the multiple parameters query prompts for the
mainreport.

 

[Duane Hookom]

You should avoid parameter prompts in queries. Use references to controls on
forms. You criteria might be something like:

Between Forms!frmDates!txtStart And Forms!frmDates!txtEnd

If you kick your application up a notch and do this, you won't be prompted
multiple times and your app will be much more professional.