Results 1 to 4 of 4
  1. #1
    combine21 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Sep 2010

    Cascading combo boxes

    I am having trouble putting cascading combo boxes in a form. I have combo2 which is from one table. My combo4 which are descriptions all come from different tables. This is the code I have in the after update of the combo two. I made sure there was no row source in combo4. Is there something wrong with it?

    Private Sub Combo2_AfterUpdate()
    On Error Resume Next
    Select Case Combo2.Value
    Case "food (gustatory)"
    Combo4.RowSource = "tbl_enrichment_food"
    Case "Manipulative (tactile)"
    Combo4.RowSource = "tbl_enrichment_manipulative"
    Case "Sensory (auditory, olfactory, visual)"
    Combo4.RowSource = "tbl_enrichment_sensory"
    Case "Cage Furniture Change Out"
    Combo4.RowSource = "tbl_enrichment_furniture"
    Case "Training"
    Combo4.RowSource = "tbl_enrichment_training"

    End Select
    End Sub

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    maybe you need "combo4.requery" between "end select" and "end sub"

  3. #3
    combine21 is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Sep 2010
    That didn't work. My second combo box is still blank after I make a selection in the first combo box.

  4. #4
    michaeljohnh is offline More Human than Human
    Windows XP Access 2007
    Join Date
    Aug 2010

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-30-2012, 09:43 AM
  2. Cascading combo boxes in datasheet view
    By Hjava in forum Forms
    Replies: 1
    Last Post: 06-28-2010, 06:02 PM
  3. Cascading Combo Boxes
    By desireemm1 in forum Programming
    Replies: 1
    Last Post: 10-05-2009, 06:00 AM
  4. Cascading Combo Boxes
    By gjw1012 in forum Access
    Replies: 1
    Last Post: 07-25-2009, 04:59 PM
  5. Problem with Cascading Combo Boxes
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-13-2008, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums