Listbox selection

[1jet]

Hi all,
I have a listbox displaying query results.
Column 1 is hidden, 2 and 3 are displayed in the listbox.

My code below shows me that lstBusinessDetails.Value gives column 1's value only. How can I get column 2's value?

Private Sub cmdDelete_Click()

Dim selection As String
Dim cmdDelete As control

Set cmdDelete = Forms("frmEditEmployee").Controls("cmdDelete")

selection = lstBusinessDetails.Value

MsgBox selection

End Sub

 

[Steve R.]

Look-up the column property in Access

expression.Column(Index, Row)

Here is an example that I have used. You will need to adapt.

Me.Text51 = Me.Combo49.Column(3)