Results 1 to 10 of 10
  1. #1
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11

    cascading combo

    Hello,

    I need help in creating a cascading combo 3 to be exact. It is as follows.


    1st - Make
    2nd - Model
    3rd - Year

    I know I don't know how to do it that's why I came to the EXPERTS for advice, guidance and help!!! Also please consider how to do the updating of the data on each combo box. Any help will be greatly appreciated.

    Thank you.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you looked at this link yet?

  3. #3
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11
    Quote Originally Posted by RuralGuy View Post
    Have you looked at this link yet?
    I've looked at the link but I don't think I'm doing it right at all.

    I've attached my database (part of it). If any body could help me out I would very much appreciate it.

    thank you.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Let's see if another link will help: http://www.fontstuff.com/access/acctut10.htm

  5. #5
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11
    Quote Originally Posted by RuralGuy View Post
    Let's see if another link will help: http://www.fontstuff.com/access/acctut10.htm
    Thank you I tried but I can only do two combo box. I'll just try another solution to my problem. Thank you for your time.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    There are two methods to do as you want. Have the RowSource of each ComboBox include a reference to the controlling ComboBox and Requery all of the subsequent ComboBoxes in the AfterUpdate event of each ComboBox. Or replace the RowSource of the subsequent ComboBoxes in the AfterUpdate event of each ComboBox. Which method are you using? I prefer the first method.

  7. #7
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11
    Quote Originally Posted by RuralGuy View Post
    There are two methods to do as you want. Have the RowSource of each ComboBox include a reference to the controlling ComboBox and Requery all of the subsequent ComboBoxes in the AfterUpdate event of each ComboBox. Or replace the RowSource of the subsequent ComboBoxes in the AfterUpdate event of each ComboBox. Which method are you using? I prefer the first method.

    Thanks ruralguy. honestly I don't know which way to proceed.

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Either way is fine, just pick one.

  9. #9
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11
    Quote Originally Posted by RuralGuy View Post
    Either way is fine, just pick one.
    well, you said you prefer the first one lets go with that one.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I believe all you need to do is complete the RowSource for the 3rd cbo and add the Requery to the 1st and 2nd cbo AfterUpdate events.

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

Similar Threads

  1. Cascading Combo Boxes
    By desireemm1 in forum Programming
    Replies: 1
    Last Post: 10-05-2009, 06:00 AM
  2. Cascading Combo Boxes
    By gjw1012 in forum Access
    Replies: 1
    Last Post: 07-25-2009, 04:59 PM
  3. Problem with Cascading Combo Boxes
    By CushingMT in forum Forms
    Replies: 0
    Last Post: 11-13-2008, 09:44 AM
  4. cascading combo form
    By tonysomerset in forum Forms
    Replies: 0
    Last Post: 08-27-2008, 02:10 AM
  5. Cascading Combo Box
    By nywi6100 in forum Forms
    Replies: 0
    Last Post: 10-23-2006, 01:45 PM

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