Unanswered: multiple selection listbox to a variable
I have a multiple selection listbox on my form. I can pass one selected value from a listbox to a variable and than use it in a query.
But how I may select multiple values and pass it to the variable to do sum( of picked values)
and than use the variable in my query???.
Dim I As Integer
Dim strPer As String ''''variable
I = 0
Do Until I = 25 ‘’’ period values in the list box from 1 to 25
If lstfields.Selected(I) = -1 Then
strPer = strPer & lstfields.Column(0, I) '''& "+" '''for the next value????