Crosstab Query - Viewing records that form the result

[Rickochezz]

Here is a screen shot of my Report created by a crosstab query - All is good to this point



What I am trying to do is if you click on any of the money amounts I would like a list to show all of the people that contributed to that list for example






Here is a look at the design of the report



This is currently what I have in the on click event for Apr-17



I need to somehow grab the [Course] value into this module.

Any help would be appreciated

Thanks
Rick

[Rickochezz]

If I change my "Where condition" to

[qryStudentCourse]![SerialMonthYear]=#4/1/2017# And [qryStudentCourse]![Course]=[Course]

I get all courses from the month and not just the one course that I am looking for in the line