Multiple Selected List Boxes...

[The Boondock Saint]

Ive got a list box with data in it from a query.. and what id like to be
able to do.. is put the options i select into a table along with a couple of
other variables... is there a way to do it?

Thanks for your advice in advance

 

[Douglas J Steele]

Are you saying that you want to store multiple values in a single field?
That's not a good idea: in fact, it violates database normalization rules.

What you need is two tables: one that stores the "main" data, related to a
second table that has one row for each of values selected in the
multi-select list box.

You can loop through the list box's ItemsSelected collection to determine
which one(s) were selected, and write to the database for each one.