Hi - I have a form, and on that form it has a subform that query results for a query that is
Code:
Select stopLightColor, Count(student) From tblStudentDay;
Which shows sample data like this
Color --- Count
Green 12
Yellow 4
Red 9
What I would like to do from here is when a user clicks on a row, a separate sub-form shows and it shows the names of the students who were that color. For example, if the user clicks Yellow, then I want the sub-form to .Visible = True
and list of the 4 names like
Studen Name
James Jones
Bob Jackson
Mitch Manfred
Sam Smith
How would I set-up the on-click event to do this?