Last value selected in a multi select list box 2

[MajP]

I have a multi select list box. As user click a record I want to return data for that record. How do I return the last item selected (not the last item in the list)? I have come up with a solution, but it seems there has to be a better way. My solution is to build a collection of the old ItemsSelected. Then compare that collection to the new itemsSelected and return the different value.

 

[ck1999]

If I am understanding what you are asking . . .
Could you declare a global variable in the form and then assign a value on the on-click method to this variable. This way it is updated and will always display the most recent item selected on the list.

       If Me.CustomerName.Selected(Me.CustomerName.ListIndex) = True Then ' test to determine if the current item was unselected
       MsgBox Me.CustomerName.ItemData(Me.CustomerName.ListIndex)
       End If

I just used a msgbox to test you could assign the variable instead.

ck1999

 

[MajP]

Thanks. I could not see the forest for the trees.