Selecting multiple options in list box and sending back to table

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

Guest

Hi All,

I have created a small database, for recording details about suppliers. Some
our suppliers offer more than one service, so i thought the best way to
select multiples would be to create a list box.

I have changed the properties to allow me to select multiple options,
however cannot get the selection to save back to the data table.

Any help is much appreicated.
 
What about something like

Dim vRow As Variant

With Me.YourListBoxName
For Each vRow In .ItemsSelected
'Do what you'd like with the selected item.
Next vRow
End With
 
You will not be able to save multiple selections in the field with a bound
list box.
If you are wanting to put individual items from the list box into multiple
fields, you will need to use bound controls for each of the fields and
programmatically populate them using the selections from the list box. This,
however, does not sound like a good plan.
 
Back
Top