Results 1 to 2 of 2
2006-01-18, 18:58 #1
- Join Date
- Jan 2006
- Thanked 0 Times in 0 Posts
Categories and Sub Categories (2003)
I am trying to create a form so that when you choose a category from the category drop down field the sub category dropdown updates to the sub categories for the category selected. I have tried a few different ways to accomplish this, but to no avail.
2006-01-18, 19:03 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Categories and Sub Categories (2003)
Welcome to Woody's Lounge!
You can change the Row Source of the subcategories combo box in the After Update event of the categories one. See MSKB article ACC2000: How to Synchronize Two Combo Boxes on a Form. This article (which also applies to Access 2003) contains a link to download a demo database with a working example.
Alternatively, you can set the Row Source of the subcategories combo box to a query with a parameter that refers to the categories combo box. See MSKB article ACC2000: How to Create Synchronized Combo Boxes.
You can also search for cascading combo boxes in this forum.
Post back if you have further questions.