multi-select listbox save & readback

  • Thread starter Thread starter cmichaud
  • Start date Start date
C

cmichaud

I have a listbox on a form that is poulated by a table. I want the
user to be able to select more than item. This i have done by changing
multi select to 'extended'....should it rather be 'simple' I the want
these selection to be saved in the database. How do i do this. I was
told to find out how to save and read-back selection. cant figure it
out...any ideas?

caleb
 
You cannot bind a multi-select listbox to a field in a recordset. The only
option you have is to use VBA to determine all of the selected items (use
the ItemsSelected collection of the listbox), and manually update the table.

BTW, the correct way to do this is to have two tables: a parent table that
contains the main information, and a child table, linked to the parent
table, with one row for each item selected in the listbox.
 
Back
Top