I have a ComboBox control, I get the data from database and add it to the ComboBox like this:
VB Code:
  1. With cboEmployee
  2.     Do Until rs.EOF
  3.         .AddItem rs.Fields("EmployeeName")
  4.         .ItemData(.NewIndex) = rs.Fields("EmployeeID")
  5.         rs.MoveNext
  6.     Loop
  7. End With
Now, I get one employee id from the database,I want to the cboEmployee display the name relating the id. I write the code like this(so foolish)

VB Code:
  1. For intCount = 0 To cboEmployee.ListCount - 1
  2.     If cboComboBox.ItemData(intCount) = intItemData Then
  3.         cboComboBox.ListIndex = intCount
  4.         Exit For
  5.     End if
  6. Next intCount

Who can help me improve the code, thanks in advance!!!