Multi Select in list box

[mikew71]

I'm running a form where one list box is returning data from a query based on the selected variables of a second list box. This works fine on single variable selections, however if I change the variable's properties to either of the Multi Select options no information is returned.

Is there a blatantly simple reason for this?

Thanks

 

[RoyVidar]

For single select listboxes, it's enough to use a reference to the listbox in the query. For multiselects, you'll need to loop the selected items, build a where clause, and pass to the query, probably using dynamic sql. Here's a sample thread702-787778.

Roy-Vidar

 

[Crowley16]

there is an itemsSelected option which returns ";" delimited text, I think, which can be used with a IN statement on your where clause...

but I've not tried this out myself...

--------------------
Procrastinate Now!