Filter Subform using List Box

**Sarah97** · 10-19-2019, 10:14 PM

Hello All!

I am next to Access and have been getting as far as I can using videos and reading online. I am trying to make a very basic search capability in a form. I want to be able to search for multiple products by using a multi-select list box.

I thought I did the VBA correctly, and the form indicated that it is filtered when I select and option and click search, but doesn't seem to narrow the form down.

Does anyone know how I can select from my list box "a" and "b" for example, and see all of the people who have those products? I want to be able to see if they have the other products as well, which I why I want each type in the same field.

I greatly appreciate and tips or advice on how to make it work!
(Cross-post:https://access-programmers.co.uk/for...d.php?t=307455)