Cascading Combo Boxes

[desireemm via AccessMonster.com]

Hi all, I am trying to make the rowsource of the Services_Covered combo box
dependent on the Catagory_for_hours combo box and I am wondering if I di this
correctly. The bosses want the rowsource to be exact, hope I'm doing this
right
When I tested the code it told me that Access can not find Catagory_for_hours.
Which I dont understand because thats what the combo box is called its not
mispelled. can anyone help pls I need for the Results of the Services_Covered
to be based off whats chosen in the Catagory_for_hours. for example if the
user picks ITP From Catagory_for_hours then the only thing that should show
in Services_Covered is

Academic Assessment;MER Completion - TANF;Career Training
Plan;Counseling;Phone Call"
Can anyone help pls


Private Sub Catagory_for_hours_AfterUpdate()


Select Case Me!Catagory_for_hours
Case "ITP"
Me!Services_Covered.RowSource = "Academic Assessment;MER Completion -
TANF;Career Training Plan;Counseling;Phone Call"
Case "Parenting"
Me!Services_Covered.RowSource = "EHS Training/Home Visit;Training/Office
Visit;Independent Study"
Case "Job Skills Training"
Me!Services_Covered.RowSource = "Independent Job Skills Training;Career
Training Workshop;Resume Writing"
Case "Culture"
Me!Services_Covered.RowSource = "SCAIR Soaring Eagles;Regalia;Pow Wow
Participation"
Case "Education"
Me!Services_Covered.RowSource = "GED/High School Diploma Preparation;Adult
Basic Education;Independent Study"
Case "Life Skills"
Me!Services_Covered.RowSource = "Drivers Education"
Case "Travel"


End Select

End Sub

 

[Douglas J. Steele]

Are you positive that the combo box is named Catagory_for_hours: that the
underscores really are there (and that category is misspelled)?

Try changing the name of the combo box (and changing the reference to it in
the code to the new name)