Results 1 to 4 of 4
  1. #1
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038

    Cascading **UNBOUND** combo boxes

    Hello Experts:

    I have a fundamental question about cascading **UNBOUND** combo boxes.

    First, please see attached database example. It includes the following:
    1. Organization table
    2. Billets table
    3. Junction table
    4. Query


    5. Form

    Additional details:
    - The junction table stores the keys between the Organization table and Billets table. There's also a staff member ID; however, for purposes of this example, I removed the staff member table.
    - Next, the query displays more detailed information and shows which billets (jobs) belong to which organization (N-Code).
    - Now, in the form, the "N-Code" combo simply displays the three (example) N-Codes.
    - Unfortunately, however, when changing the N-Code, the associated billets (jobs) are currently not properly showing in the 2nd combo.

    What VBA code needs to be added to have the two combos in sync (based on N-Code selection)?

    Please remember both the form AND the combos are UNBOUND... and I'd like to keep them unbound.

    I'd welcome if you could provide specific change recommendations.

    Thank you,
    EEH
    Attached Thumbnails Attached Thumbnails Query.JPG  
    Attached Files Attached Files

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Your problem has nothing to do with them being unbound, which makes no difference. You're not referring to the name of the first combo in the row source of the second combo. Should be:

    [Forms]![Form]![cboNCode]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    skydivetom is offline VIP
    Windows 8 Access 2010 64bit
    Join Date
    Feb 2019
    Posts
    1,038
    Actually, I just figured it out...

    I changed the row source to: SELECT DISTINCT Query.RA_Billet_Title FROM Query WHERE (((Query.N_Code)=[Forms]![Form]![cboNCode])) ORDER BY Query.RA_Billet_Title;

    Thank you anyhow...

    Cheers,
    EEH

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I beat you by a few seconds.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 5
    Last Post: 01-07-2019, 01:51 AM
  2. Cascading Combo Boxes
    By cbramsey in forum Forms
    Replies: 3
    Last Post: 05-18-2017, 06:26 AM
  3. Cascading Combo Boxes
    By Lou_Reed in forum Access
    Replies: 20
    Last Post: 12-20-2016, 01:50 PM
  4. Cascading combo boxes
    By SunTop in forum Forms
    Replies: 2
    Last Post: 12-10-2016, 11:29 AM
  5. Cascading Combo boxes
    By finsmith in forum Forms
    Replies: 10
    Last Post: 02-12-2013, 09:37 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