[AccessD] Filter on Sub-Report

Gustav Brock gustav at cactus.dk
Tue Aug 17 13:21:12 CDT 2004


Hi Rocky

Why don't you apply the filter to the queries which drive the
subreports? 

/gustav


> I have two reports with two different record sources which I have placed on another report.  So they're sub-reports but not linked parent-child to the main report.

> Each runs okay standalone, but when I run the main report with the two sub-reports on it it blows up on the statement Me.Filter = ""; says the setting you entered isn't valid for this property. 
> Same with Me.FilterOn = False.  

> These statements are in the _Open event of the sub-report, preparatory to creating a filter from the user's selected options on the form which calls the report.

> Anyone know why I can't set the filter on the sub-report?




More information about the AccessD mailing list