Listbox and multi select

[orv]

Not sure if this has been covered here before...if so my apologies. Also I
have tried to find answers elsewhere with no luck.

On a form I have a list box bound to tblnames, field Names. I also chose
'extended' for multi select properties.

My question is this:

On the form (used for input), is it possible to have several selections,
from the list box, and have that info placed into a table?? Not sure if this
is even possible Would I need to send it to a query first? I'm sure there
would have to be some code for the 'on_click" as well.

TIA,
Orv

 

[tkelley via AccessMonster.com]

Dim varSelected As Variant

For Each varSelected In Me.lstYourListBox.ItemsSelected

'code to perform your action

Next varSelected