Results 1 to 2 of 2
  1. #1
    ArchonUltimatum is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Posts
    1

    Need combo box to be dependent on another, with duplicate values

    I just learned Access for school and already found a project to work on. There are just a couple of things I am hung up on. I have a form with two combo boxes. I need to be able to select one or more values in the first box, and the selections in the second box need to be linked with the corresponding values in the first.

    That sounded confusing, but this is the best way I can describe it:
    A to 1,
    B to 2,
    C to 1,
    D to 1
    Where the letters are the values in the first box, and the numbers are the second.

    If anyone has some time to help me out with this and maybe a couple more issues, I would greatly appreciate it!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Combobox allows only one item to be selected unless it is bound to a multi-value field. You don't want that.

    You seem to describe cascading or dependent combo/list boxes. Review: http://www.datapigtechnologies.com/f...combobox2.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. SUm duplicate values then delete duplicate rows
    By DonKaponne in forum Queries
    Replies: 1
    Last Post: 09-14-2014, 04:18 PM
  2. Replies: 3
    Last Post: 05-06-2014, 12:57 PM
  3. Replies: 5
    Last Post: 01-29-2013, 03:38 PM
  4. Help with dependent values
    By ceejsing in forum Access
    Replies: 6
    Last Post: 08-05-2011, 06:36 AM
  5. Replies: 3
    Last Post: 02-26-2009, 10:17 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