'Multi Select' on List Boxes not working

G

Guest

Hi,
When I set up a list box and changed the mult select setting to either "simple" or "expanded", entries are not saved in the table. Does anyone know why?

Rob
 
S

Sandra Daigle

When used as a multiselect list (simple or extended), the value of the list
box control will always be Null. If you think about it, this makes since
each row only stores one value. If you want to use the selected items to
create multiple records you have to write code that takes the selected items
and creates the records. You can see an example of how to do this in my
SelectRecords example on http://www.daiglenet.com/msaccess.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top