I have a database that requires a multi select option from a list box on a form. I have managed to get the list box to populate from a seperate table "DistrubuteTo" (as you know you can distubute a letter to more that one person). Using the simple select, the user can highlight more that one option. I need to now to add the data to to a "main table" where one of the columns is called DistrubuteTo, but i cant get it to populate the column. I can if they just select one, but if they highlight two or more options it dont work. If i put a seperate big text box on the form and a seperate add button on the form; as you click add it populates the text box with the multiple selections. then when you click the add record button, it populates my main table. Do i need any special VB
code? Any help please?