retriving data for a multiple select list box...

[Guest]

Hi guys,

i have a multiple select list box on my form, and it saves the selections I
make
into the field just fine.,
but when i open the form on an existing record, it does not show up the
selections that are in the
record already ...

any ideas how to get a multiple select list box to show the selectinos in
the current record ?

thanks,
kevin

 

[John Vinson]

Hi guys,

i have a multiple select list box on my form, and it saves the selections I
make
into the field just fine.,
but when i open the form on an existing record, it does not show up the
selections that are in the
record already ...

any ideas how to get a multiple select list box to show the selectinos in
the current record ?

thanks,
kevin

You cannot (well, you *can*, but you should not) store multiple values
in a field, and a listbox does not automatically store the selected
values anywhere unless you have VBA code to do so.

What's the table structure? Where do you want these values stored?
Would a second table and a Subform perhaps be a more suitable choice?