Hi, I currently have a small database I'm trying to set up to track my Embroidery files.  The database has two tables (Embroidery Files and Categories) joined with a junction table as a file can have many Categories and a Category can include many files. I've created a form with a multi-select Listbox in an effort to find Embroidery files that are assigned a specific Category or Categories.  When I select just one category ( i.e.Christmas), I am getting the correct results.  When I select two or more categories, all I get is the category with the lowest ID.  I've included a Message Box that shows my Select statement.  I'm sure this is where the problem resides, but I'm new to VBA and to using subforms so I'm struggling. Any suggestions/help are much appreciated. I will attach images.