Populating table info from table in drop down list

[shellaccess]

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

[June7]

Dependent combo/list boxes. Review http://datapigtechnologies.com/flash...combobox2.html

Filter form records. Review http://datapigtechnologies.com/flash...tomfilter.html

Or build form/subform arrangement. http://office.microsoft.com/en-us/ac...010098674.aspx

Or some combination of dependent combobox and form/subform.

[shellaccess]

Thanks but I really need a solution and not more reading material at this point. Also, the links did not help since I am asking for something that is slightly more advanced-- or at least seems to be since its not working

[June7]

Those links do have solution, especially the DataPigTech tutorials. They visually demonstrate the techniques you need to learn and are narrated. They explain better than I can in a forum post.

Why isn't it working? The technique demonstrated for dependent comboboxes is exactly what you describe you want. However, you need to be aware that dependent comboboxes that have a RowSource that is a lookup don't work nice in Continuous or Datasheet view forms.