Results 1 to 3 of 3
  1. #1
    SunTop is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Aug 2016
    Posts
    93

    Combo Box Selection

    I have three tables and one Form



    Table_1
    Table_2
    Table_3
    Form_1

    Table_1 is linked to Table_3 in One-to-Many Relationship and Table_2 is linked to Table_3 in One-to-Many Relationship

    Form_1 has a few Tex Boxes that enters data into Table_2

    Form_1 also has a Subform that enters data in Table_3 and it contains two Combo Boxes, the first Combo Box picks values from the ID field of Table_2 and the second Combo Box picks values from the ID field of Table_1.

    When the user clicks on the second Combo Box in the Subform, it displays all the values, even the previously selected values, I need this Combo Box to display only values that are not already entered in Table_3 and hide the values that are already entered.

    Thank you for your help

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The query for the combo will be an OUTER join.
    Show all items in the src table NOT currently in the picked list.

    the cbo must be refreshed Everytime an item is added the the table.
    cbo.requery

  3. #3
    SunTop is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Aug 2016
    Posts
    93
    Thank you ranman256, you have solved my issue.
    God bless you Sir.

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
  •  
Other Forums: Microsoft Office Forums