List Box Multiselect

  • Thread starter Thread starter Pia
  • Start date Start date
P

Pia

Hi!

How do you make a list box field retain the items selected? I am trying to
create a list box that has multiple items in it, where you can select more
than one item.

I was able to create the list box, and the options are shown, and i can
select more than one item, HOWEVER, as i go to the next or previous record,
the item i had selected appears in all the other records..?

what am i doing wrong?
 
You're not doing anything wrong: it's your expectations that are wrong <g>

You cannot bind a multiselect listbox to a data field. This is because
storing multiple values in a single field is a violation of database
normalization principles.

Rather than trying to store multiple values in a single field, you should
have a second "child" table, related to the existing table, and use a
subform, rather than a listbox.
 
Back
Top