Filter Sub Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top