S
Stephen @ ZennHAUS
Hi Guys and Gals
I have a number of reports that are all launched from the same dialog box,
which is used to specify filter criteria for the report. I have used code
to create a WHERE clause which is stored in a String variable and then
passed to the form as part of the DoCmd.OpenReport line of code.
It works a treat EXCEPT ... If I have a report that has one or more
subreports, it does not pass the WHERE clause to the subreport(s). Since
all of my main reports that have subreports do not have any data bindings,
there is no data to filter.
How do I get the subreports to use the WHERE clause (or filter property) of
the parent report?
As additional information, you can refer to my post "Specifying conditional
Criteria in a Query or Report" which was posted on 23/4/2009 in which I
explain that I have changed to using code to create a WHERE clause for the
reports instead of having the queries directly access the content of the
textbox on the criteria form because I now need to supply more criteria than
just the date.
Cheers
Stephen @ ZennHAUS
I have a number of reports that are all launched from the same dialog box,
which is used to specify filter criteria for the report. I have used code
to create a WHERE clause which is stored in a String variable and then
passed to the form as part of the DoCmd.OpenReport line of code.
It works a treat EXCEPT ... If I have a report that has one or more
subreports, it does not pass the WHERE clause to the subreport(s). Since
all of my main reports that have subreports do not have any data bindings,
there is no data to filter.
How do I get the subreports to use the WHERE clause (or filter property) of
the parent report?
As additional information, you can refer to my post "Specifying conditional
Criteria in a Query or Report" which was posted on 23/4/2009 in which I
explain that I have changed to using code to create a WHERE clause for the
reports instead of having the queries directly access the content of the
textbox on the criteria form because I now need to supply more criteria than
just the date.
Cheers
Stephen @ ZennHAUS