Multiple Sub Forms with Query Filter

[Gabriel2012]

Hello, our employees have a "scorecard", this form pulls data from four seperate queries into the form itself and three seperate sub forms. The issue I run into is that I have a filter in the queries for the "Year" and "Period (Month, based on accounting period)", and the users are prompted to type in the year and period multiple times for the form to load correctly. How can I set this up so that they only need to enter the "Year" and "Period" once and it will apply to all of the subforms?

I am not proficient in SQL so hopefully your answer does not involve custom coding, but if it does please be specific, thank you very much!

[June7]

The query is set up with parameter input prompts? I NEVER use input prompts. Instead, have user input to textboxes on form. The query parameters would reference the textboxes. If the textboxes are on the same form then will need code to requery the form. http://datapigtechnologies.com/flash...tomfilter.html