second field of listbox

[matrixindicator]

I have a listbox on my subform with numbers (eg. 0,5 1 1,5 ...)

To get the total in my mainform I first create a total in my subform. The problem is he makes a sum of the first field and this is the key, index field. So I need to say make a sum of the second column. I know perhaps a dummy question, but forgot it and spend a lot of time to find

column(1) ?

=Sum([refID29].[Field](1))

 

[PWise]

is refID29 then name of youe list box then it shoulb be .column(1)

 

[matrixindicator]

but he seems to be set [] around column and this is not working anymore.

=Sum(([refID29].[column](1)))

it should be

=Sum(([refID29].column(1))