Apply filter for Printing

[Andrew]

I have 5 tables. One uses [Report No] and link to fields [ID]. [ID] is
duplicates ok and indexed, [Report No] is no duplicates and indexed. The
"child tables" use the [Report No] in the [ID] Can I write a filter that
links all the info to send to reports using anly the [Report No], [ID]...I do
have queries that send info to reports but filtering a report is based on the
[Report No] Field.

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Download the sample database discussed in that link. It explains how to
build a Filter string dynamically, based on a form where the user enters
their filter values in unbound controls. The example applies the filter to
the form, but it is exactly the same process for a report. In the end, you
use the filter string in OpenReport.