combo box display field name on textbox

[ultra5219]

hi again.. how to set combo box for example doctor name with 2 field which display doctor name and department.


lets say if i select doctor name : Eric and automatically display doctor department as: Surgery in text box. then i can save patient record on appoinment table
anyone? here is my sample db

Thanks..

[amrut]

Set the textbox controlsource to =[YourComboBoxName].Column(1). This expression cannot be used for bound text box.

[ultra5219]

i did try but still not successful, can u edit the sample access for me which i attach above? so that i can explore how u do? sorry im still new on access.. so might be learn more

[amrut]

See the modified database. I have added one unbound text box to show use of the expression. I think you do not have to save the department unless one doctor belongs to more than one department.

[ultra5219]

Thank You now i understand already.. using expression to control between combo box and text box