Search results

Excellent JR. That's solved the problem. Many thanks.

One thing I have noticed about the way JANR's approach is working is that it only picks up the suppliers where I only have one item in the column to be searched. If there is more than one word in the column it won't pick it up. How do I get around this, I'm sure it's very basic. I think I need...

Thank you for your replies. I now have a button on my form which, when a search is completed, lists the companies that supply the product requested. Amazing. My preference would be for me to be able to click through the selected companies, one at a time, on the form, without having the...

Hi I've started a new database of suppliers, I have a table and a form. I know I can go into query and do a search on the products column of the table but is it possible to create a search box on the form which, when you put a product into the box, will go through all the suppliers who sell...