hi everyone
i have got a new problem this time. I have managed to populate the data

and all in the Combo box and its doing first letter select. but the
trouble is earlier in the list box (form type) when i used to select an

option i used to set the data in another cell.
it was giving the index of the data and i was doing some calculations
on the basis of this index value(it was a numeric value.)

but now when i select from the combo box its giving me the Data value
from the list which is of no use as far as my calculations are
concerned as its a data value and (not numeric). so what should i do to

get the index value instead of the exact text from the list in the
combo box.


I tried using bound column and set another column containing the index
of the list but its not working. even column count is of no use


plz help out.
thanx in advance