Yes, it is possible.
First, I would recommend using the InitializeRow event for a calculation like this, rather than AfterCellUpdate.
Anyway... remember that the DropDown services the entire column. So you can't rely on the active or selected row in the dropdown being correct for any given row. So you will have to find the correct item on the list each time you perform your calculation.
So what you do is, in InitializeRow, get the cell from the ValueListColumn and then access the ValueListResolved property. This will return an IValueList. The IValueList has a method called GetText on it, which takes a value and finds the item on the list that matches that value and returns to you the text and the index of the matching row. You don't really care about the text here, but what you need is the index.
One you have to index, you can use that to index into the correct row on the dropdown:
Me.UltraDropDown1.Rows(index).Cells("Value").Value
Hi Mike,
Thanks for the response, your solution worked but it did raise one more question. How does the grid column that contains the dropdown valuelist know what column within the valuelist contains the value and which one contains the text? With the ultracombo's you actually specify a Value Member and a Display Member and so to accomplish the same behavior within the grids I've created a dropdown with an ID and a Text column and I just hide the ID column. It appears that this works correctly I'm just wondering how it knows that the ID column is the one with the value not the text and vice versa.
Jeff
UltraDropDown and UltraCombo both have ValueMember and DisplayText properties. In fact, these properties exist on a base class that both controls derive from.
If you use a ValueList, then the ValueItem has separate properties for DataValue and DisplayText.
All three object (UltraDropDown, UltraCombo, and ValueList) implement the IValueList interface, which is what the grid deals with. Actually, the grid doesn't deal with the interface directly, the grid deals with the editor and the editor deals with the interface. :)
Ahh, yes . . . of course they do and I actually set the values several weeks ago in the dropdowns. Please forgive my stupidity, I was sleep deprived last night. I appreciate all your help.