You've said nothing about your tables or their fields, nor did you provide any information about the query. What you ought to have is a table for "companies" (suppliers? customers?), one for products, and assuming any given product could be related to more than one "company", a junction table that accommodates such a many to many relationship. Then you could enter any given company name into the proper field from that table and get a set of records that shows which products are related to that company. You might think that only the companies and junction table (tblCoProds?) would be required, but the unique product id (often an autonumber) from tblProducts is what ought to be in the junction table as a foreign key. That means you'd be looking at a number rather than a product id, which wouldn't help much.
If that is not your setup, or if not much of that makes sense, you should step back at research db normalization as well as query design based on good normalization.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.