Set filter of a subreport from a form

  • Thread starter Thread starter John
  • Start date Start date
J

John

I cannot seem to figure out how to set a filter value of
not only the main report (which I can do), but I also have
two subreports that need that same filter when choosing a
selection from a form.


Thanks,
John
 
Simplest is to base the subreport on a query that references the text box on
the form.

In the Criteria row of the subreport's query, under the relevant field,
enter something like this:
=[Forms][NameOfYourSubFormHere]![NameOfYourTextBox]
 
Back
Top