adding items selected from a listbox to a junctiontable

[Atoga]

Hi All, Can you help me with this issue, please?: I am just about to write a code that adds items selected from a listbox to a junctiontable. I would like to be able to add one or more Skills from a listbox to a Course/Qualification. The listbox is on pop-up form that comes up when a certain Course/Qualification is selected in a combobox on another form. After selecting Skill(s) from the listbox, I would like to click on Add to Course/Qualification button and by this add the selected skills to the Junctiontable `CourseQualSkill` So I would like to add the selected Skill(s) to the Course/Qualification that was selected from the combobox in the starting form. I guess the code would look something like this,but I dont know what to write to Append jcntblCourseQualSkill.:

Private Sub cmdAddSkilltoCourseQual_Click()
For x = 0 To Me.lstSkillstoAddbyCourseQual.ListCount - 1
        If Me.lstSkillstoAddbyCourseQual.Selected(x) = True Then
            'Append jcntblCourseQualSkill
         End If
    Next x
End Sub

[ranman256]

I find the 'no code' approach is easier.
list box 1 is the list of available options to pIck
list box 2 is the picked items.
when user dbl clicks list1, execute an append qry that puts the item in a table (list2)
when done, join the picked list to whatever needed.

User can delete from list2 with a delete qry.

[pbaldy]

Sounds like:

http://www.baldyweb.com/MultiselectAppend.htm