multiple selection in sub form

[trevor40]

Hi All,
I am currently using the code below to populate email attachment list from a list box on my form.
i would like to know if it can also be done with a subform control. EG
select multiple rows in subform and use that to create the attachment list?

    'get attachments
    With myItem
        For Each vItem In lst.ItemsSelected
            If Not IsNull(vItem) Then
               myItem.Attachments.Add = lst.ItemData(vItem)
            End If
        Next
        Set lst = Nothing
    End With

[orange]

Not sure I really understand your question. Are you saying you want only certain attachments for certain emails?
Whatever you have in your listbox (the row source),you could put in a subform. But I'm not sure what would be the difference.
If the user can identify the things to be attached from the listbox, that seems straightforward.

Now if it's an academic exercise to show it is possible, that's a different story. I could see showing each record and having a check box or clicking on the record in the subform and having code to add that record to the attachments.

[June7]

Looping through records selected by highlighting is possible but the selection must be for sequential records.

Whereas a multi-select listbox allows non-sequential selection. As would a bound checkbox in a form.

[trevor40]

thanks, I'll have to stick with the list box then.