Help pls!

[tru-]

I have created a form which contains fields also found in tblProducts.

frmProducts - ProductID, Name, ProductCategory, ProductSubCategory, Description, Price, Quantity

I have made cascading combos for the ProductCategory and ProductSubCategory fields, the row source for these two fields are in a single table, tblCategories

So at the mo I can add products, put them into their categories etc and all the correct changes to the tblProducts are made.

However, I want to create another form but as opposed to defining what category and subcategory a product is using the cascading combos (and therefore changing the field values of ProductCategory and ProductSubCategory in tblProducts) I want to use them to filter the products.

E.g. ProductCategory > Case
ProductSubCategory > Server

ProductID, Name, Description, Price, Quantity

Server Cases will then be shown 1 at a time using a Next Record button to view the next product which has the ProductCategory=Case AND ProductSubCategory=Server values.



I believe I do this by using a query, sorry if Im wrong with anything, Im new to access!
Thanks for your time, appreciated!

 

[Brianwarnock]

You are correct that you use a query to filter the records and base your form on the query.
I would design a frmFilter to drive this. This unbound form would have text boxes to enter the values to be filtered on and a command button to open the form based on the query, the query would be run automatically.
The query would use criteria such as Forms!frmFilter!textboxname

Hope this helps

Brian