Hello, you all have been fantastic and very helpful before, so I'm here to ask another question. Here's a question that probably has a very simple answer, but it eludes me.
OK, I have a subform datasheet with a "Thing" field that previously let you choose values from a dropdown menu from a limited list of options, lets call them "Thing1", "Thing2", etc. At the top of the form, I added several filter buttons for it. So, for instance, I hit the "Thing1" filter button and it only displays the records with "Thing1". I used an apply filter macro for this, and it worked perfectly. So far so good.
But now conditions have changed. Previously, I did not allow multiple values. But now I have to take into account that a record might have both a "Thing1", "Thing2", and "Thing3", etc, not only one of them. So I changed the field to a list box drop down menu instead. And this works fine. However, now when I try to use the filter button, I get the error message: "The multi-valued field "[Thing]" cannot be used in a WHERE or HAVING clause."
So my question is, how can I set the macro so the filter button will show ANY records with that value? So for example, I hit the "Thing2" button, and it displays all records that have "Thing2", regardless of the other Things it might have? I tried playing with AND and OR functions and I couldn't get it right. For simplicity, I would prefer to keep using macros instead of vb for this particular function, if possible.