Check selected item in Access listbox

[SimonFinn]

Hi

I need to check if a selected item in a listbox in access is the last item in the list using VBA.

Cheers Si

 

[dan1967]

You need to put this code in the list box's Click event:

Private Sub List1_Click()
If List1.ListIndex = List1.ListCount - 1 Then
    MsgBox "This is the last item"
Else
    MsgBox "This is not the last item"
End If
End Sub

The ListIndex will show you the integer index value for the item 0 through ListCount-1.

Dan.