Finding how many selections made in list 2

[fileman1]

I have a list box, set as simple.

Is there a way to know when just one item has been selected in advance of the code below?

      For Each item In Me.DW.ItemsSelected
        strlist = Me.DW.Column(1, item)
      Next item

If one item (word) has been selected then I want to offer an edit function of the word. The offer of the edit function gets taken away if mulitiple items have been selected.

 

[MajP]

you can use the count property of the itemsselected collection.

 

[fileman1]

Thanks, I used

Me.Label33.Caption = Me.DW.ItemsSelected.Count

 

[fileman1]

Now I cannot find how to get the output/value of the item selected.

If Me.DW.ItemsSelected.Count = 1 Then
??

 

[PHV]

What about this ?
strlist = Me.DW.Column(1, Me.DW.ItemsSelected(0))
or this ?
strlist = Me.DW.Column(1, Me.DW.ItemsSelected(1))

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

 

[fileman1]

Thankyou, yes that works for me perfectly. Have a good weekend