VBA Help needed.....?

Question

Hello all
I am beginner to VBA. I populate all the professers name in one combobox , and when i select one professer name then thier designation, department, and specialisation (I m thinking of either label or textbox to display theses value ) will automatically display from database field designation
For each field i have table in database.

How to code for this? Ca anybody please give some ready code? I really appreciate that.
Thanks in advance

Answer 1

MyNewTxtBox = DLOOKUP("department", "tblProfessors", "name = comboBoxName")

Place that in the after update property of the combo box and play with it, you will get it