list box -- Multi Select

  • Thread starter Thread starter Lara
  • Start date Start date
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 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...
 
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
 
Back
Top