Report, Subreports, Multiple Queries

[kfboren]

I am wondering if someone can help me. I have created 10 tables, 10 queries for the tables and 10 reports from the quearies. The creteria for the queries is the field named "month". I have created one main report, which includes all 10 of the subreports. When opening the main report I have to enter the creteria month which is the same for all 10 queries. How can I open this main report and only enter the creteria one time which would satisfy all 10 queries? I am running Access 2007, OS Vista.

[NeoPa]

On the subreports, set the LinkMasterField s & LinkChildFields . This should link them all together for you.

[NeoPa]

A related question has been posted in Linking Unbound Forms.