List box

[Pass-the-reality]

On my table MainTable, I have a field called Category. On my form
frmMainTable (which is linked to MainTable) I have added the field Category.
I changed Category to a list box and selected the row source of TableCategory
(which stores all of the options) What properties on the list box do I need
to change so that if I pick multiple items from the list box, it will save
the data in my MainTable.

 

[Douglas J. Steele]

Assuming Access 2003 or earlier, it's not possible.

Access 2007 introduced a new data type for multivalued lists: your table
field would have to be one of those.