retriving data for a multiple select list box...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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?
 
Back
Top