Multiselection not working for listbox

[doranhenrie]

When I click on Yes for multiselection and save it it goes back to No. What do I need to do to be able to get multiselection to work. Do i use the ctl key to select multiple items once I get it working.

[Villeroy]

Multi_Select_Listbox.ods

(15.89 KiB) Downloaded 74 times

[doranhenrie]

Sorry, I'm using Base not Calc.

[Villeroy]

What do you expect to be written into the linked field of the current record when you select multiple values?
A multiselection listbox does not work with the regular database binding nor does it work with a spreadsheet (as demonstrated in my sample sheet).

A many-to-many relation works like this: [Example] Relations reflected by list boxes in forms (relation between persons and things)

[UnklDonald418]

A ListBox query has a display field, usually a string of text that makes sense to the user and a boundfield usually an integer that uniquely identifies the display field in the table being queried.
When the user selects a text string from the ListBox control it stores the boundfield value in the table field that the ListBox control references on a Base form.
Since that table field in a normalized database can contain a single value, multiselection makes no sense.
You may have a defective (not normalized) database design or need something other than a ListBox.
With a more detailed explanation of what you are trying to accomplish, or better yet an example database, we might be able to offer suggestions.