How can I filter a subreport (change the record source) at run time 1

[rewdee]

Hi All

I have a report that lists some values. I was asked to put in a list of definitions at the end of the report. I have created a list of defintions in a table but since the report can change as to which fields will be listed, I need also to filter or change my subreport. I cannot seem to find a way to filter a subreport. Can anyone Help Me? I sure would appreciate it.

Thanks,
Rewdee

 

[JerryDennison]

This is a tough one. I've had a similar situation and the only way I was able to solve it was to use code to open the subreport, set it's filter property, close and save the subreport, then open the main report.