How should I do to make a record filtered when I press a command button?
What I'm after is that I have two forms. The first one is with 4 different product categories and the second one is with ALL products.
If I for example press the "Product category 1" I want to open the second form with a filter so it only shows the products in "Product category 1".
I assume you know how to set the buttons to open the various forms...then just set the record source to say like ProdCat= "Product Category 1" using SQL or you can set filters on forms by opening the form for category 1, and under the data tab you should see filter. Just type the actual name i.e, fruit.