I have a list box whose multiselect prpoerty is set to "Extended". I like my query to filter data based upon the selection(s) I make in my list box. But it doesn't work. I am using this as my criteria:
Product Field
Criteria: Forms![MainForm]![lbx_Product]
I also tried to use this criteria:
Forms![MainForm]![lbx_Product].ItemsSelected
But both criteria didn't bring back anything.
However, when I change the multiselect prpopery of my list box to "None", the criteria starts working.
How can I fix it so that my query filters data based upon mutilpe selections that I make in my list box.
Thanks a lot in advance.
Jay
Product Field
Criteria: Forms![MainForm]![lbx_Product]
I also tried to use this criteria:
Forms![MainForm]![lbx_Product].ItemsSelected
But both criteria didn't bring back anything.
However, when I change the multiselect prpopery of my list box to "None", the criteria starts working.
How can I fix it so that my query filters data based upon mutilpe selections that I make in my list box.
Thanks a lot in advance.
Jay