add codes to combo box/cascading combo

[desireemm via AccessMonster.com]

Hi all I got a request from the boss. She wants it to be easier for the users
to enter to enter categories into the combo boxes without having to look
through a long list.

This is on a word document but there are 7 categories and connected to them
is 28 subcategories. Each Sub belongs to a catelgory.

So when the user chooses

Category
ITP - Individualized Training Plan

Subcategories

Academic Assessment
MER Completion - TANF
Career Training Plan
Counseling
Phone Call


Category
Parenting

Subcategory

Parenting Training (w/instruction)
Parenting Home Visits
Parenting Independent Study - O Travel


Cateogry
Job Skills Training

SubCategory

Job Skills Training (in office)
Career Development (Active Job Search)
Career Training (Workshops)
Resume Writing


and the list continues. What I am trhing to do is every time the user chooses
a Category in the Second combo box the Subcategories that pertain to that
category are all that they see. So they only have those to choose from.

can anyone help please

 

[Benjamins via AccessMonster.com]

Hi

You will need to have a table to store your info.

tblCategory
----------------------
CategoryId
CategoryName
SubCategoryName

For the Category combobox row source: "SELECT CategoryName FROM tblCategory
Group By CategoryName"

For the SubCategory combobox row source "SELECT SubCategoryName FROM
tblCategory WHERE CategoryName Like '" & NZ([CategoryComboBox],"") & "'"

Make sure you have to requery the SubCategory Combo box upon Category
combobox is changed or else the list would not change for the SubCategory
combobox