I have 2 subforms/subreports withtin a main form.
The two forms are a lists. When I select or highlight an item (row) from the 1st subform/subreport I want the item related to my row selection to display on the second subform.
In other words in subform 1 I have a list of classrooms. When I select a classroom I want the list of students to show in subform 2.
Please help