Combo box entry based on the ItemData

[MarkT]

How do you find a combo box entry based on the ItemData. I'm loading a combo box with entries from a description field. I'm using the primary key for that table as the item data for each description. Now if I know the primary key how do i display the correct item in the combo box. Here is a quick sample.

Assume I have loaded a combo box with this data

Apple ItemData = 1
Orange ItemData = 2
Banana ItemData = 4
Grapes ItemData = 7

Now lets say I know the itemData is 4. How would I display Banana

[vbNeo]

Doesnt it have an Index X function, like a list box? Or am i misunderstanding something ? hehe

[MarkT]

The listIndex is sequential. I can't use that because Items may have been delete in the table so the ItemData will not match the ListIndex

[vbNeo]

k

[si_the_geek]

Originally posted by MarkT
The listIndex is sequential. I can't use that because Items may have been delete in the table so the ItemData will not match the ListIndex

Yes it will, the List and Itemdata may be two separate arrays, but they are synchronised. ie: Itemdata(3) will ALWAYS be the itemdata for List(3), no matter how many items have been removed/added.

This means you can do a simple for loop on the itemdata, then set the listindex to the matching array position.

[MarkT]

Cool, thanks!

[vbNeo]

I knew it! hehe