Printable View
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
Doesnt it have an Index X function, like a list box? Or am i misunderstanding something ? hehe
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
k
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.Quote:
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
This means you can do a simple for loop on the itemdata, then set the listindex to the matching array position. ;)
Cool, thanks!
I knew it! hehe