Problems storing list box items into a table

  • Thread starter Thread starter ScottK
  • Start date Start date
S

ScottK

I have a list box that you can select multiple items,
which you can then copy over to a standard text box by
clicking on a command button. I need to store all those
items that have been copied to the text box into a table
for future reference. I have assigned a control source to
the text box, but it still will not the data over to the
assigned table. Any help be great. Thanks.
 
Scott,

Either I'm not very clear on what you're saying, or you're not very clear on
what you're trying to achieve...
Multiple selection list boxes need some code to "read" the selected items
which, as implied by the name, are often more than one; that's why they
cannot be bound to a table field.
Getting the selected items accross to a text box ??? You still won't be able
to link that to a table field, unless it is a text / memo field, and you use
some kind of separator... but is this what you want? I doubt it.
In most cases, storing selected items would involve creating a separate
record in a table for each selected item (through the code used to "read"
the multiple selection list box).

What's the deal?

HTH,
Nikos
 
Back
Top