How to save multiple selection from a list box in a bounded field

L

Lana69

I am trying to set list box control "lst_Services" in a form "frm_Producers"
which is bound to "Type_Sevrices" field in a table "Mapped_Producers". The
goal is to alow multi selection from a list box and store these in the table.
When I set MultiSelect property of the list box to Simple or Extended, the
stored value of the list box is Null.

How to solve this problem? Is this possible to do with list box control OR I
should take another control in consideration, and which one?
 
K

Klatuu

You can't store multiple values in one field. A MultiSelect list box will
only return null because the items are stored in a collection.

If you can describe what you are trying to accomplish, perhaps we can help
with the how to.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to display values in 2nd list box from 1st list box selection 2
Link a text box based on drop down box with four options MS Word 365 0
Creating a Search using a combo box and then creating a report. 4
No option to create a list in SharePoint Site 0
Insert name and adress from a list in a word document 1
Drop down list control value in vba 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
list or combo box 0

Top