Hi,
I've been struggling with this seemingly simple problem for two days now!! How can I reference a value in a listbox? Nothing I try seems to work!! This is my current code:
 Me!lstCheckOut.SetFocus
 Me!lstCheckOut.Selected(0) = True
 data = lstCheckOut.ItemData(0)
 MsgBox data

Please help if you can.
Thanks,
Dave

Have you tried Me.lstCheckout.Column(0)? Column(0) being the bound column of the listbox, ie. if column 1 is bound it would be Column(1). Or you might do something like this:

Sub Private SomeButton_Click()

Dim strCheckout As String

strCheckout = Me.lstCheckout.Column(0)

MsgBox (You have selected " & strCheckout & " from the listbox!")

End Sub

Hope that helps!

In regard to my previous post, the column doesn't have to be bound in the listbox for that to work. If the listbox had three columns, you could do that to get the selected value for any of the three.

Thanks Mccoy. I was neglecting to reference the columns.