Filtering Records in Sub-report

[JohnHarkins]

Hi!

I've searched my brain, Access 97 & 2000 books, the web and I must be missing something. Hope you can help me.

My report contains a subreport that shows records linked in a parent/child relationship on two fields ("series" and "cycle&quot. The subreport should show records that match the two fields _unless_ the supervisor's name is "4CD". (Yes, I know 4CD doesn't sound like a supervisor's name!)

My idea was to filter records in the subreport based on the text field in the main report's page header that shows the supervisor's name. I used the following string in the filter property of the subreport:

reports![rptProduction Report]![txtSupervisor]) ="4CD"

That didn't work. I thought, "well, maybe the problem is in my reference." So, I checked and tried to use:

reports![txtSupervisor]) ="4CD"

Still nothing. Is it the way I specified my reference? Can I not, as one thread indicated, use a filter in a subreport?

I'm now resorting to rethinking how I get records in the subreport in the first place, but I'm not really happy about my failure.

Thanks, John Harkins