Sub Reports

[kwin]

Can any one help, I am using access 2007
I have a main report with 4 subreports in it. In the main query I need to set the critera to [Enter year] so I can change the data in the report but when I run the report I have to enter the year four time is there any thing I can do so I only need to run this once

 

[pbaldy]

Enter the year on a form and have them all refer to that in the criteria:

Forms!FormName.ControlName

 

[kwin]

how do I make the other refer to that in the criteria

 

[pbaldy]

Wherever you have

[Enter year]

make it

Forms!FormName.ControlName

 

[kwin]

It is still not working having touble with understanding how to do it

 

[pbaldy]

Can you post the db?

 

[kwin]

thanks for your help but got it working