Where Clause in OpenReport Method

[JulieFB]

Hi,

On a form I have a drop down menu where users can multiselect Departments to include on a report. My report includes a detail section + 3 subreports in the report footer.

In my OnClick, I use the WHERE clause to indicate which departments to show on the report, but the WHERE clause only works for the detail section of my report, it wont pass to the subreports.

Any ideas on how to do this ? I am pretty desperate !!

Thanks a bunch !

Julie

 

[SkipVought]

Hi,

You might want to post this in an Ms ACCESS forum like Microsoft: Access Reports forum703

Skip,
[sub]
[red][/red]
[/sub]