Results 1 to 3 of 3

Combo Box Selection

  1. #1
    cegomez1 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2014
    Posts
    7

    Combo Box Selection

    I am creating a small table to track certain parts that are being replaced on certain pieces of equipment, and was wondering if there was a way to where if I select an item from a combo box in Field 2 (for example equipment), if the selection of a certain item can dictate the items available in the combo box for field 3. For Example:

    If I select Crane 1 in the combo box in field 2, it will change the list in field 3's combo box to only the items associated with Crane 1.

  2. #2
    Bob Fitz is online now Access Developer
    Windows 7 32bit Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,099
    Yes. This is commonly asked question in Access forums. Search for "Cascading Combo Boxes" in any Access forum or Google.
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,707
    The 2nd combo query looks at the 1st combo value.

    cboEquip.rowsource = qsEquip
    cboItems.rowsource = qsEqItems1Equip

    Now the query 'qsEqItems1Equip' will reference the cboEquip to get its data:
    Select [Item] from table where [Equip] = ' " & forms!frmMyform!cboEquip & "'"

    Now no matter what the person picks , the 2nd cbo will read it to produce results by that 1 value.

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

Similar Threads

  1. Replies: 7
    Last Post: 03-30-2015, 10:04 AM
  2. Replies: 4
    Last Post: 10-13-2014, 09:20 AM
  3. Replies: 5
    Last Post: 04-09-2014, 06:57 PM
  4. Replies: 3
    Last Post: 07-03-2013, 10:38 AM
  5. Replies: 1
    Last Post: 10-30-2012, 10:29 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
  •  
Tech Forums: Microsoft Office Forums