choosing multiple entries in combo box on a form

[hammerman]

I'm quite new to creating a database. On my navigation form, I have a dropdown list/combo box that contains up to 16 possible selections. The user should be able to select more than one item, but can't, when using the navigation form. In the man form that this 'writes to' the selections can be made, with checkboxes in front of each item in the list; but not in the navigations sub-form. the Navigation sub-form only shows the list in a column. I don't see any properties that explicitly allow more than one suggestion or restrict to only one, so am I using the correct control? If so, what am I not doing?

[ItsMe]

The List Box Control has a Multiselect property that you can adjust to equal "Yes".

[hammerman]

ItsMe: Thank you. I see it; I currently have only a few records that the user would select more than one listbox.item, so I could have used a ccombobox and ignored the other item(s), but...!
I don't know the frequency that future records could have more than one type, either. I researched and found that more than one selection causes a 'NULL' to be stored in the table this form feeds/populates. Is there a snippet of code that is available to store the text of the selected items in a cell in a table? The form (which has the listbox) categorizes the contents of a shipment when all the items are not of the same type. ps. I'm using Office 365 w/Access2013.

[ItsMe]

I do not understand why any example would leave you with the impression a Multiselect List Box includes Nulls. You will want to test for Null. Test to make sure the User selected something before writing to the table.

Here is a snippit to iterate multiselect.
https://www.accessforums.net/forms/l...tml#post224893