ComboBox - Select my value

[TragAnn]

I've got a combobox that I'm populating from the database. That works fine and I am storing an ID in the ItemData for each entry.

What I'd like to do is to identify one of those items that matches a single value. What's the easiest way to loop through the ITEMDATA of the rows listed in a combobox??

Thanks....

[JMuller]

Try this...

For i = 0 To Combo1.ListCount - 1
    MsgBox Combo1.ItemData(i)
Next i

[Iain17]

I am not sure if this is what you mean or not. This just loops through every item in the list and compares the ItemData to ?????

For i = 0 To Combo1.ListCount - 1
  If Combo1.ItemData(i) * "????" Then
    'insert whatever here
  End If
Next i