List box

[Alvin Hansen]

Hi'
I have a list box where would like to
make several choise in and then
make some new records with this choises.
I can set the list box to have several chois
but how do i get this into my table.

Hope someone can understand me.

Alvin

 

[Rob Oldfield]

It would probably be something like this...

dim itm as variant
for each itm in me.lstControl.itemsselected
dosomethingwith.... me.lstControl.itemdata(itm)
next

.....which will loop through the selected items. The 'dosomethingwith' could
be various things... recordset manipulation, running a named query or
running some SQL in order to add records.