Parameter Sub Reports

  • Thread starter Thread starter Pat G
  • Start date Start date
P

Pat G

Hi,

I have 2 sub reports that are grouped into a single
report. Both sub reports ask for the same
parameter "Advisors Name".

Problem is it asks twice for the the parameter once per
sub report. Is there a way to have it ask only once?

Also the user has to type in the advisor's name can I
have a drop down list of available adivsors instead?

Also after opening the report I tell it to print and it
asks for the parameter again, how come?

Thanks
 
This sounds like the best reason yet to create a small form with a combo box
for the user to select the Advisor. Your criteria would then be something
like:
Forms!frmSlctAdv!cboAdvisorID
 
I suppose,

The way the user access the report right now is threw a
shortcut. So that would mean changing the shortcut to
load the form which I suppose I could do... ahhhhhhh
sooooooo much to do.
 
Back
Top