Listbox ItemsSelected Issue

[Jean9]

On my form is a single listbox that when a value is selected in a combobox object, code is executed to select certain list items based on the combobox selection. The issue I am having occurs at the time when the user de-selects one or more items in the list and leaves other items selected (or pre-selected via the code). When subsequent code loops through the listbox items to see what has been selected, it does not "see" the list box items that the user left as selected (or pre-selected via the code originally). It negates the purpose of setting the selected items via code if the user has to re-select them in order for code to recognize the item as selected. What code can be used to see the "selected" items that were initially set as selected via the code?
Thanks,
J9

 

[Jean9]

And...it looks like the last 'deselected' item is the item that the code thinks is 'selected'...

 

[PHV]

the item that the code thinks is 'selected'
Which code ?
Have a look at the ItemsSelected collection of a multiselect ListBox.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Jean9]

Below is the code for original selection

    With LstAPPS
        For i = 0 To .ListCount - 1
            ' Find occurences of User Access and select list item
            If UserHasPerms(sUSERID, .Column(1, i)) Then
                .Selected(i) = True
                .Enabled = True
            End If
        Next i
    End With

Below is the code for the subsequent check of selected item after user has deselected one or more items from the list but not all items:

For Each VARPATH In .ItemsSelected
    sSQL = "Delete * from " & .Column(1) & " where UserName ='" & Me.CbxUSERID & "'"
    DoCmd.RunSQL (sSQL)
Next VARPATH

This code is being executed for items that were last selected OR deselected rather than "seeing" the selected items (that may appear in the list as selected and sequentially before the last selected or deselected item) that were set as selected in the first code snippet.

J9

 

[PHV]

You don't use VARPATH in your loop ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Jean9]

VARPATH is just a variable dimmed as variant. What method should be used to execute code for just selected (highlighted) items in the list?
J9

 

[Jean9]

Nevermind, I understand what you mean. I should have used VARPATH in the "Delete * from " & .Column(1)" to read Delete * from " & .Column(1, VARPATH).

Got it.

Thanks!
J9