Transfering multiple list box selection to a table

[colinmunnelly]

I have a list box on a form which looks up the records from a customer names table. When the user selects the customers to be associated whith the current record of the form i need this information to be written in the 'associated customers' column of the form table. Hope someone can point me in the correct direction.

 

[Fizzio]

You will need to loop through the selected items in the listbox and add them to a recordset using VB. You may be better off using a subform though which requires no programming.Check out this link for some advice and examples