Too many prompts on a report

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I have a report containing multiple sub-reports, each su-
report are link to a different query, Only the primary
query as a promt. When I try to preview the report the
prompt appears a multiple of time before I can preview the
report, plus when I try to print this report everything
starts over again. Is there a way to manage that the
prompt would come up only once.

Thanks,
Daniel
 
Don't use parameter prompts. Use a reference to the value contained in a
control on a form.
 
Duane,
Thanks for the response, but it is not quit clear for me.

When you say "Use a reference to the value contained in a
control on a form." What do you mean? Also, I absolutly
Click to expand...
need a prompt on the original query used for my primary
report. This report is going to be used by many different
VP's whitin my company and each of them would like to be
able to prompt the region they need.

Dan.
 
You create a form [frmSlct] with a combo box [cboRegion] that lists all
different regions. Then you set the query's criteria to:
Forms!frmSlct!cboRegion
You can do something similar with your subreport record sources. If you have
starting and ending dates, you can add two text boxes to your form
[txtStartDate] and [txtEndDate].

This allows you and your VPs to more easily select dates, regions, and other
criteria. You can set defaults, test for integrity, and do much more than is
possible with a parameter prompt.
 
Back
Top