Filter Sub Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cynthia - 19 Oct 2004 22:17 GMT

I have a form that calls up another filter that sets a glove variable from
the users selection. It thens calls up a report that is filtered by this
global variable. In this report I have a subreport. When I try to put the
filter variable in the event proceedure on open for the subreport I get an
error message THE SETTING YOU
ENTERED ISN"T VALID FOR THIS PROPERTY. How can I get the subreport to
filter with the variable the user selected?

Reply to this Message

cynthia - 19 Oct 2004 23:35 GMT

I just figured this out I had to use the record source of the sub. I put the
variable
in the on open event . i.e. Me.RecordSource = strSubQry
I put the filter criteria in with the query text. i.e.
strSubQry = "SELECT [Supports Cold].* FROM [Supports Cold]WHERE " &
gstrFilterText & ""

gstrFilterText is my global variable

> I have a form that calls up another filter that sets a glove variable from
> the users selection. It thens calls up a report that is filtered by this
[quoted text clipped - 3 lines]
> ENTERED ISN"T VALID FOR THIS PROPERTY. How can I get the subreport to
> filter with the variable the user selected?

Reply to this Message