>>>Suppose you have a dropdown combo that contains 2 or more columns. The value of the combo is tied to column1. How would you retrieve the value from the other columns for the selected item?
>>>
>>>Thanks in advance for any help on this one.
>>
>>this.ListItem[this.ListIndex, col], also depending on the RowSource for the combo you may use Alias.Field (in case Alias is the RowSource) or Array[this.ListIndex,nCol] in case of array.
>
>Thanks Naomi, worked like a charm.
>
>Terry - Thanks, but if I changed boundto I would just have to change it back again to its original value.
You're welcome and in the meantime I already re-created the lost piece of code <g>.
If it's not broken, fix it until it is.
My Blog