Set filter of a subreport from a form

[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

 

[Allen Browne]

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]