ListBox count (Access2K)

Topic

New Reply

Is there a way to show how many items are selected in a separate textbox, as they are selected in a multi select listbox?
Also to subtract from that number if a selection is clicked on then clicked again to remove it.
Thanks for any help provided

Reply | Quote

Replies

There sure is. The magic combination of methods, properties and events are: the AfterUpdate event of your multi-select enabled list box and the ListBox.ItemsSelected.Count property. Whether you click to choose, or click to unchoose a selection in a list box, you’ll fire the AfterUpdate event for the control. You can examine the number of selected items, and do something with it. So, to come close to your scenario, imagine your list box is named lstTest, and the text box is named txtCount. The code would be something like:

Private Sub lstTest_AfterUpdate()
    Dim intNumChoices As Integer
    
    intNumChoices = Me.lstTest.ItemsSelected.Count
    
    Me.txtCount.Value = intNumChoices

End Sub

Good luck!

Reply | Quote

Thanks, That worked Great
Happy Holidays

Reply | Quote