Combo Box question for Access 07

[desireemm]

Hi guys I have a question about combo boxes. We have a two combo boxes one
is the [Catagory for hours] so when you look at the drop down it says
"LifeSkills";"Education";"Culture";"Travel";"Job Skills
Training";"Parenting";"ITP";"Phone Calls";

the next combo box has the subcatagories for the[Catagory for hours] its
called [Services covered] and when you open the drop down here is what you
see "Academic Assessment";"MER Completion- TANF";"Career Training
Plan";"Counseling";"Phone Call";"EHS Training/Home Visits";"Training/Office
Visits";"Indpendent Study";"Indpendent Job Skills Training";"Career Training
Workshop";"Resume Writing";"SCAIR Soaring Eagles";"Regalia";"Pow Wow
Participation";"GED/High School Diploma Preparation";"Adult Basics
Education";"Computer Skills";"Indpendent Study";"Drivers Education";

What I would like to happen is that when the user chooses ITP from the
[Catagory for Hours] the only thing that shows up in the [Services Covered]
combo box is "Academic Assessment";"MER Completion- TANF";"Career Training
Plan";"Counseling";"Phone Call";
and when they choose Parenting the only thing that will show in the
[Services Covered] is EHS Training/Home Visits";"Training/Office
Visits";"Indpendent Study";

So basically when the User chooses a Catagory the only thing that shows up
in the subcatagory combo box [Services Covered] is the subcatagories
pertaining to that Catagory. is this possible??

the reason why I have to do it this way is becuase there is a report that is
based off these two combo boxes and the colum headings of the report are the
based offf the [catagory for hours] the headings are Parenting, ITP, Job
Skills training, Education and travel. so the combo boxes have to be
seperated. Does that make sense??

 

[Dirk Goldgar]

Hi guys I have a question about combo boxes. We have a two combo boxes
one
is the [Catagory for hours] so when you look at the drop down it says
"LifeSkills";"Education";"Culture";"Travel";"Job Skills
Training";"Parenting";"ITP";"Phone Calls";

the next combo box has the subcatagories for the[Catagory for hours] its
called [Services covered] and when you open the drop down here is what you
see "Academic Assessment";"MER Completion- TANF";"Career Training
Plan";"Counseling";"Phone Call";"EHS Training/Home
Visits";"Training/Office
Visits";"Indpendent Study";"Indpendent Job Skills Training";"Career
Training
Workshop";"Resume Writing";"SCAIR Soaring Eagles";"Regalia";"Pow Wow
Participation";"GED/High School Diploma Preparation";"Adult Basics
Education";"Computer Skills";"Indpendent Study";"Drivers Education";

What I would like to happen is that when the user chooses ITP from the
[Catagory for Hours] the only thing that shows up in the [Services
Covered]
combo box is "Academic Assessment";"MER Completion- TANF";"Career
Training
Plan";"Counseling";"Phone Call";
and when they choose Parenting the only thing that will show in the
[Services Covered] is EHS Training/Home Visits";"Training/Office
Visits";"Indpendent Study";

So basically when the User chooses a Catagory the only thing that shows up
in the subcatagory combo box [Services Covered] is the subcatagories
pertaining to that Catagory. is this possible??

the reason why I have to do it this way is becuase there is a report that
is
based off these two combo boxes and the colum headings of the report are
the
based offf the [catagory for hours] the headings are Parenting, ITP, Job
Skills training, Education and travel. so the combo boxes have to be
seperated. Does that make sense??

This page shows two different ways to do it:

http://www.mvps.org/access/forms/frm0028.htm
Forms: Limit content of combo/list boxes