Parameter Sub Reports

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
 
D

Duane Hookom

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
 
P

PaT g

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