Subcategories based on categories

[Guest]

I have a table "Products" in access with 4 fields:
Primary Key - Product Name - Category - Subcategory
1 - KD32 - TV - PSONY
2 - ST25 - VCR - PHONY

Subcategory field values come from another table "Subcategories" with 2
fields:
Primary Key - Subcategory Name - Category
1 PSONY TV
2 PHONY TV
3 CHONY VCR
4 RONY VCR

Category field values in both Products and Subcategories tables come from
another table "Categories" with 2 fields:
Primary Key - Category Name
1 TV
2 VCR

What i want to do is when i select a Category for a product in table
Products to be able to select only the Subcategories witch have the same as
the Product Category in the field Category (eg when i select TV as products
category to be able to select only from PHONY and PSONY for Subcategory.

Is is possible?
Thanks

 

[Graham R Seach]

Your question is the same as that posed by Cyndi just a little while ago,
and the answer is the same.

Essentially what you have to do is reset the 2nd combo's RowSource when you
select a value from the first one. In your case the value you'll pass is the
Category. See if the following page helps:

http://www.pacificdb.com.au/MVP/Code/ComboRS.htm

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia

 

[aragorn]

http://www.pacificdb.com.au/MVP/Code/ComboRS.htm

Worked great!!!
Thanks a lot.