I consolidated 10 reports into one main report with 10 subreports. Each subreport reports data on 7 different companies. I linked each master/child field to company. Now when I want to view or print I am prompted with a parameter field in which I must enter the company name to view/print that specific companies information on the 10 different subreports.

How do I make a macro that lets me only enter the company name in once and it will automatically generate the full new report (with 10 subreports in it)? It's annoying entering the same company in 10 times, and then running that report seven times (one for each company).