List Box Multiselect

[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?

 

[Douglas J Steele]

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.