[ms_access] help needed by this newbie on saving multi select value to a table

[Lyanne Rheeza Ong]

Hello everyone,
   
  this is a code i created to be able to get the multiple users i have selected 
in the form. i was able to select the users in the form an select folder 
however i am unable to save the user name to the table. i am able to save the 
folder name. what should i do?
  
[code]
    Dim vtr As Variant
    Dim frm As Form, ctl As Control
    Set frm = Forms!Form_Assign
    ctl = frm!listFolderUserList
    ctr = ctl.ItemsSelected.count
        
    If ctr > 0 Then
        selList = ctl.ItemsSelected
        FolderID = Me.FolderName.Value
        For Each vtr In Me.listFolderUserList.ItemsSelected
          usrID = Me.listFolderUserList.ItemData(vtr)
          sqlStr = "Insert into FolderLDAP (FolderID, UserID) " _
          + "(" + FolderID + "," + usrID + ")"
          CurrentDb.Execute sqlStr, dbFailOnError
          
      Next
    End If
  [/code]
  please help!
  thanks,
lyanne   



L y a n n e  R h e e z a  C.  O n g

 



       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.

[Non-text portions of this message have been removed]