Unanswered: multiselect listbox as query parameter
How do you format the results of a multiselect listbox to be used as the criteria in a query?
I have a form with a multiselect listbox. There is a textbox on the form to hold the selected items after being formatted through code. The field I want to filter is a text field. I can format them to use as a where condition to open a form, but I can't get it formatted to use as criteria in a query (I have tried several formats).
The goal is to use the selection to filter a record set and email it as an attachment. Niether SendObject nor the TransferSpreadsheet allow for a seperate filter or where clause and I want to send the results of a saved query rather than one created through code.