Windows XP 
Access 2007
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";"J ob 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??
Reply With Quote
