A
Andy Ingall
I have a list box with column headings and 4 columns.
the data in column 4 is a number. I need to get capture
that number so that i can use it to run in a query.
I have the following code.
Private Sub List23_DblClick(Cancel As Integer)
Dim a As String, varItem As Variant
a = a & Me!List23.Column(3, varItem)
MsgBox a
End Sub
When I double click on a row the msgbox just gives me the
column heading. Any ideas what is wrong?
Andy
the data in column 4 is a number. I need to get capture
that number so that i can use it to run in a query.
I have the following code.
Private Sub List23_DblClick(Cancel As Integer)
Dim a As String, varItem As Variant
a = a & Me!List23.Column(3, varItem)
MsgBox a
End Sub
When I double click on a row the msgbox just gives me the
column heading. Any ideas what is wrong?
Andy