I'm stuck....

I have a report which displays a week's worth of construction jobs in a calendar view, with a subreport following with more details on the jobs (address, type of work, etc). To create the report the user has to select a starting date and the construction region from a list box. All worked just fine until I tried to make the region a multi-select list box.

I was able to get multi-select criteria to pass to the main calendar-style report, but the region criteria isn't passed to the subreport...it still shows all regions.

Any suggestions on how to get the multi-select criteria into the subreport too?

Thanks,
Julie

How are you doing it for the main report?

Bob-
I'm using the following code attached to a command button on the form with the multi-select listbox.

The subreport is called srpt_weekly_detail & it pulls data from the same query as the main report, just displays more detailed info in a tabular report.

Thanks,
Julie