I have made a report with 7 sub-reports that are each based on a different parameter query. The report works just the way I want it to with ONE major problem...
When I run the report, it is asking 7 (yes, 7!) times to type in the parameter of each sub-report. Since the parameter will always be the same, I need to find a way to type in the parameter just ONCE.
Any takers????:D

--Kaleen

You may for example save your parameter value in an invisible textbox of your main form, and have your subform recordsource queries refer to that control?