Hello-
I am trying to figure out how to do the following:
I have a table with the following info:
Field1 Field2
student teacher
john mr. smith
mark mr. smith
todd mr. smith
alan mrs. Jones
steve mrs. Jones
I have a form that has a drop down with an option for individual teacher (based on the one previously selected) and all teachers. I want it to populate a second drop down with students assigned to that teacher, and all students if all teachers are selected from the first drop down. How can i do this? I have tried using a query and also some basic VBA script from looking through MS Access books and am not having any success at all.
I.E:
Mrs. Jones is using the DB.
Mrs. Jones selects "her students" and the the second drop down should populate with just her students. She will then proceed to select the student and enter grading info. If she selects "all students" all students should show in the second drop down to be selected for grading.
Thank you in advance