Storing values of multiselect box into a table

[kristinem via AccessMonster.com]

I'm trying to set up a multiselect box on one of my forms but I'm not
familiar with VB code to be able to store and save the values in the table.
I've tried searching these forums, but I haven't really found anything that
fits my needs (that I know of). Does anyone have any links to online
tutorials that could probably help? Or if you know of a thread here that
answers my question, could you post the link? Thanks!


Kristine

 

[Allen Browne]

Kristine, a multi-select list box is not the choice if you want to store
values in the table.

Instead, you need to create a related table (one-to-many relation) so you
can store multiple records matching the one in your main table. You can then
use a subform, and add as many rows as apply to the record in the main form.
You can do this without writing any code.

Even if you were quite at home writing code, I would still suggest that this
normalized approach is the way to go.