>>>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.
Aye, well you didn't say "temporarily" retrieve. That, of course, is for when you want to specify the column to retrieve from, when not the default, on a "permanent" basis.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.