providing parameters

[elefantmannen]

I have now constructed a big report consisting of some sub reports. I have the sub reports created on questions like select everything bla bla where id=parameter. This is so I can create one report for every unique office. The thing is now that when I run a report it wants to have the parameter for all of the subreports so I have to feed this id like 10-12 times. Have I designed everything like a jug head or is there a qay to feed the parameter just once for all the subreports? (It is the same id for all the reports, a unique id for each office)

 

[jdgreen]

Do you launch the report from a form? If so use the criteria in the query to get the ID from the form. You can do this a couple of ways. Enter the following in the criteria instead of your [Enter ID]:
=Forms![frmYourForm]![ID]
or you can create a variable in the module to call the ID from the form.

John Green