Report Referenced Query

[lugnutmonkey]

I have a report that displays call volume year over year broken down by months. I would like to have the ability to click on a month within the report and then have a month over month report open up with the month that was clicked(I already have the report made up for month over month calculations).



My question is can I have the query behind the Month report use the month clicked in the Year report as a criteria. I currently have the criteria set to a form using the criteria of

 Where (((Departments.[Department Name])=[Forms]![PC_GUI]![Dept])

Is there a similar method for referencing a clicked field in a report?

[June7]

It should be simple to test this. Possibly the report has to be in Report view not Print view.

[lugnutmonkey]

I don't think I can have the query reference a click on the text box as an entered parameter, if that makes any sense. I have decided that double clicking a month will bring you to a form that has a text box populated with the months. you would then select a month and click a next button to bring you to the appropriate report.

I have a one question now, I will populate the form with both the name of the month and a numerical value that reflects the order of the month based on the fiscal year. How would i go about making both the "Month" and "Month ID" appear in the text box?