list box -- Multi Select

L

Lara

Hi,

I have a list box on a form and the Multi Select property is set to
Simple/Extended. My problem is that I can't save any multi selected
values to a Table.

Any help would be appreciated. Thanks in advance.
 
A

Albert D. Kallal

A list box when bound to a field can only have one value.

In fact, a field in a database can only have one value anyway. That means
without a whole bunch of code to load up the list box, and then a whole
bunch of code to un-load the listbox values to a another table would be
possible, but a messy bit of code.

If you need to store "many" values, then you need to use a one to many
relationship. That *usually* means you create another table, and use a
sub-form...
 
H

Hugh O'Neill

Lara said:
Hi,

I have a list box on a form and the Multi Select property is set to
Simple/Extended. My problem is that I can't save any multi selected
values to a Table.

Any help would be appreciated. Thanks in advance.
Click to expand...


That's because a Field in a Table will only store one value, not
several at the same time.

Hugh
 

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

Similar Threads

Multi-Select 0
How to save multiple selection from a list box in a bounded field 1
Access 2003 Data Not Saving? 0
Creating separate tables for multi-select list box selections 6
Multiple answers in a form 8
Create Multi-Select List box 3
Multi-Select LIst Box Not Appearing in Text Box 2
Multi Select on a Form 3

Top