Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Location
    Brooklyn
    Posts
    25

    Unanswered: multiple selection listbox to a variable

    Hello ,
    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????
    End If

    I = I + 1

    Loop

    QUERY

    Thank you for your help! and Happy holidays!

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Perhaps this site might be of some use to you.
    Me.Geek = True

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •