ListBox Selected Record

[bahalzamon]

I am attempting to pull the information from the selected record so I can update my forms text boxes and for additional functionality later on.
I am experiencing a couple of issues. I found this code online and I would think it would work, but I never see the message box saying "test".


The second issue is how do I pull the data from the selected record so I can save it into a variable for later manipulation?

Private Sub List16_Click()
    Dim i As Integer
    For i = 0 To List16.ListCount - 1
        If List16.Selected(i) Then
            MsgBox "test"
        End If
    Next i
End Sub

Any help is always appreciated, I am also somewhat new to Access, so I would appreciate the info being dumbed down for me.

[June7]

Is your listbox set for multi-select? If not, don't need the looping structure.

Post the listbox RowSource sql statement.

[bahalzamon]

I just looked up multiselect and it is set to no which is correct (i think) I just want them to click one at a time.
I am just unclear on how to use the currently selected item within the list box.

I would think something like this would work, but I know I am just unfamiliar with the VBA/Access language.

Me.textBox = List16.selectedItem[certainColumn]

Here is the requested SQL statement

SELECT [queryComputerStatus].[Barcode], [queryComputerStatus].[Computer].[Manufacturer], [queryComputerStatus].[firstName], [queryComputerStatus].[lastName], [queryComputerStatus].[checkOut] FROM queryComputerStatus;

[June7]

You can either set textboxes = to columns of listbox or set variables in VBA. Refer to columns by index. Index begins with 0. With single-select listbox, expressions in textboxes could be:
=
[List16]
=
[List16].[Column](1)
=
[List16].[Column](2)
=
[List16].[Column](3)
=
[List16].[Column](4)

[bahalzamon]

HAHAHA, I am so dumb, I JUST found the answer and was coming back to post that I found it after about 30 min of Googling. =P
Thank you again June7 for your Extremely fast and awesome responses. =)
-Bahalzamon