Passing values to subreports

[Sweetpea2U]

I have a report with multiple subreports that was originally using one
selected value passed onto the subreports. Now I need to be able to select
multiple values to pass to the subreports. What is the most efficient way to
accomplish this with minimal input from the end user?

Right now the user can select the report from a list which just passes the
date to filter the report by. Now I need them to be able to select the date
and the city and then pass both values on to the subreports. Is there an easy
way to accomplish this in Access? I'm currently using Access 2003.

Thanks.

 

[Klatuu]

How are you passing the date?
If you are using the OpenArgs property, then you can format it so you can
separate it in the report's Open event.

Another method is to reference the form's controls from the report to get
the value you need.