I Need Help Applying Filters to My Forms

[Benjamin Bolduc]

I work for a company that produces condiments, mainly vinegar. Im trying to set up a database to keep track of the labels for all the different products. There are over 125 different brands of labels and 5 or 10 different sizes/types/ and flavors for each brand. So here's what Im trying to do:

Im trying to make a switchboard that has an alphabetical list of all the brands. Each brand should have a hyperlink to a new page with a list of the products for that brand. Then clicking on the product will bring you to a form to edit Inventory and Order information.
Please is someone can help with suggestions or references I would very much appreciate it.

 

[David R]

Have you looked at the 3rd option in the Combobox wizard? It might get you to where you're going....
Another option is nested combo boxes, where the first box holds the brands, the second gives the types of labels for that brand. Try this article, or do a search on "link combo box": http://support.microsoft.com/support/kb/ARTICLES/Q97/6/24.asp (this uses macros, which I don't recommend) http://www.access-programmers.co.uk/ubb/Forum4/HTML/000570.html
HTH,
David R

 

[Benjamin Bolduc]

Thank you for responding. Im still having trouble though. Now when I try to querie my Inventory table by brand it lists the all the brands like 5 times. (Since there are several different products for each brand). I just want each brand to come up once and show all the products for that brand. This is so frustrating, Please someone help!

 

[David R]

http://www.access-programmers.co.uk/ubb/Forum4/HTML/004454.html has two possible solutions for this, based on whether you use a table or a query for your combo box source.

HTH,
David R