B
Brian
I pass several criteria to a report (via a query) from the contents of combo
boxes on the form from which the query is called.
In order to all the users to select multiple items for a single criteria, I
am attempting to use a multi-select list box to pass one of the criteria to
the query. I got as far as ListBox1.Selected and ListBox1.ItemData to read
the contents of the list box, but how do I pass the results to the criteria
in the query?
This must somehow include the Or operator, because In could result in
spurious results if, for example, one item on the list is "AB" and another is
"ABC". If "ABC" were selected in the list box, both "AB" & "ABC" would meet
the "In" criteria.
boxes on the form from which the query is called.
In order to all the users to select multiple items for a single criteria, I
am attempting to use a multi-select list box to pass one of the criteria to
the query. I got as far as ListBox1.Selected and ListBox1.ItemData to read
the contents of the list box, but how do I pass the results to the criteria
in the query?
This must somehow include the Or operator, because In could result in
spurious results if, for example, one item on the list is "AB" and another is
"ABC". If "ABC" were selected in the list box, both "AB" & "ABC" would meet
the "In" criteria.