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

    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
    Posts
    1,295
    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
    Posts
    31
    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
    Posts
    61

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