Refering to a particular column in a list box

[srb3464]

I want to be able to use the different columns from a list box.
ie. I wand to creat a calculation based upon the data in column 2 for one feild then use the dat from column 3 for a differnt calculation.

I can use the bound field for one but the how do I refer to a different one?

I have a list box called List39.

I can get to Me.List39 but this just returns the bound field

 

[Mile-O]

Me.MyListBox.Column(0) ' First Column
Me.MyListBox.Column(1) ' Second Column

etc.