Sending multiple selections from a 'drop down' list in a Form to an append query

[videozvideoz]

In Access I have a form with a drop-down list. I have set the form to 'multiple select' so I can select more than 1 item at once. At the end of the form is a button that runs an append query. How do I get an 'append query' to insert all the items I have selected? If I have a drop-down that only allows me to select 1 item it works fine, but when doing multiple selections it just returns a blank. Screenshot below to show multiple selection. Thanks

 

[crazypabs]

Hi hopefully this is what yo uare looking for...

Option Compare Database
Option Explicit

Private Sub Command0_Click()
Dim myItem

For Each myItem In Me.List1.ItemsSelected

DoCmd.SetWarnings False

DoCmd.RunSQL "INSERT INTO Table1 ( Field1 )SELECT '" & Me.List1.ItemData(myItem) & "' AS Field1;"

DoCmd.SetWarnings True

Next myItem

End Sub


cheers

Matt

 

[videozvideoz]

Thanks Matt. Sorry for being a little bit thick, but i don't know VBA. Which parts of the code so I need to replace with my identifiers?