how do I pull out particular field by selecting one option from c.

[Guest]

I hv created combo to select department. by selecting particular department
the teachers name should display in the screen in text button. one teacter
will be in one department or more.

everytime I change department, the teachers name applicable to that
department should display.

Thanks in advance

 

[Guest]

Is the teachers name in the combo as well as the department ?
If it is then you can set the control source of the text box to
=YourComboName.Column(1)
If it is not in the combo you will habe to look it up in the table that it
is stored
=DLookUp("Teacher","YourTable","Department = '" & YourComboName & "'")