Filtering a form but...

[johny678]

Anyone has any idea about how to filter a form depending on values of a subform???
For example:
There is a main form that displays the students of a school one at a time and a subform that displays the courses that each one has selected. A button on the main form opens an InputBox so that the user can enter a course to see the students that have selected it. So I want after the user presses enter to have the main form filtered to show only those students.
Hope my example helps!!!

 

[aleb]

The way you want it No.
Your main form is set to display a single record at a time, your subfrom displays all the courses by student. Now you want to make the subform a main form and the main form to become a sub.
Well ... just create another form which will be called in by clicking on the course name field on your subform.
Or create unbound form, place 3 listviews controls.
1 list - Students
2 list - Courses ( the values will depend on the the value selected in the first control )
3 list - Students ( the values will depend on the values selected in the second control )

 

[Pat Hartman]

Take a look at my many-to-many sample database in the samples forum to see how both sides of this relationship work.