Assigning value to textbox when an item in combobox selected

[minu]

Hello all

I am beginner to VB I populate all the professers name in one combobox ,If i select one professer name then thier designation will automatically display in textbox from database field designation

rs.Open "SELECT name,designation FROM profile", con
cboMenu.Clear

Do Until rs.EOF
cboMenu.AddItem rs("name")
cboMenu.ItemData(cboMenu.NewIndex) = rs("designation")

rs.MoveNext
Loop
rs.Close

this code dispaly all professers name,if i select on professer name her designation automaticaaly dispaly in textbox

In which event of combobox i write this

plz help

[CaptainD]

Hello all

I am beginner to VB I populate all the professers name in one combobox ,If i select one professer name then thier designation will automatically display in textbox from database field designation

rs.Open "SELECT name,designation FROM profile", con
cboMenu.Clear

Do Until rs.EOF
cboMenu.AddItem rs("name")
cboMenu.ItemData(cboMenu.NewIndex) = rs("designation")

rs.MoveNext
Loop
rs.Close

this code dispaly all professers name,if i select on professer name her designation automaticaaly dispaly in textbox

In which event of combobox i write this

plz help

I would proably put it under the change event.

txtProfessorName.text = cboPrefessors.text

[minu]

It just display the profeesors name whom i select in the combobox,but what i want actually if i select one professors name then their corresponding designation will dispaly int he textbox from datbase

can u help me again
thnx