Add a multiple choice list on a form that creates new lines in the destination table (1 Viewer)

Hi all,

I'm currently trying to add a multiple option box on a form for different pot sizes.

I know it's possible to use the multi-value combo box and the multiple choice when using a list box but 'm not entirely sure if it will generate two different lines on the destination table i'm sending the information to.

Does anyone have any good suggestions for a multiple selection box that would allow me to tick what I wanted and in succession create new lines in the table it's being saved to based on how many multiple choices were selected?

Hope that makes sense.

Many thanks

How about:

http://www.baldyweb.com/MultiselectAppend.htm

you can using your listbox ItemsSelected property.
if you have a button there, insert the code
below to it's Click Event.

this will insert each selected items in the listbox.
all controls, tables and field names should be
replaced with the ones you have.