List box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top