Combo box in a form

[diana]

I have students and teachers in a table

In a form I would like to have one contol box with the teacher name linked to a combo box with the student names. so when a student name is chosen the teacher's name would automatically refresh

How do I go about this

Thank you!

 

[Van T. Dinh]

You will have to describle your Table Structure with relevant Fields, the
relationship you set between Teachers and Students and the description of
your Form.

I am not sure from your description whether you store Teachers and Students
in the same Table or separate Table but if you store them in the same Table,
it is likely to be an incorrect design.

--
Van T. Dinh
MVP (Access)

I have students and teachers in a table.

In a form I would like to have one contol box with the teacher name linked

to a combo box with the student names. so when a student name is chosen the
teacher's name would automatically refresh.