parameter query in sub report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top