I know I've beaten this issue to death in other posts but here's what I am consistently seeing when using ANY kind of multiselect options when the options list is SQL driven. I am using a form event to insert records to an SQL table but I have confirmed the data is not inserting to the standard 'View Form Results' table either.
Examples:
'Question1' with 3 options we'll call val1,val2 and val3.
In a checkbox group when selecting all three options, $(question1) is inserted as blank.
In a listbox with multi-select selected and whatever number you put in "Row Numbers" (whatever the heck that is supposed to be used for) and selecting all three options$(question1) inserts ONLY the first item. In fact, after I re-edit the question, the multi-select is set back to single select (it won't 'stick').
The ONLY way I can make multi-select work is to KEY IN THE OPTIONS MANUALLY but then the result when all 3 options are selected are:
** val1
val2
val3
Why, when populating the options list with an SQL query do the options not work??? This works when using a 'single select' just NOT with a multiselect.
Also, why the asterisks before the first option? And just what is the 'Row Numbers: (Enter the Row Numbers for this field)' option for? It's not in the documentation anywhere.