Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: One combo box dependent on another

    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


    Code:
    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

  2. #2
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    sorry I accidentally posted this twice

  3. #3
    Join Date
    May 2005
    Posts
    1,191
    Shall we keep discussion to this posting then?
    Me.Geek = True

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •