Filter Combo Box Dropdown Selection values based on data selected (1 Viewer)

adityamoitra

New member
Local time
Today, 02:02
Joined
Feb 8, 2017
Messages
1
Hi I have a combo box on a subform where the user can select from a list of product family values (see attached screenshot). The product family values come from the product family table. I want to be able limit the dropdown in the combobox to only display those values that have not been selected. In other words, I want to filter out the values that have already been selected in the combobox. In the screenshot attached, I have selected "Quality" and "R&D" as the product families. But, when I go to add a third product family, I want the dropdown to NOT display "Quality" and "R&D". I'm having some difficulty in implementing this in access. Any help would be appreciated. Thanks.
 

Attachments

  • Combobox.png
    Combobox.png
    6.7 KB · Views: 117

Ranman256

Well-known member
Local time
Today, 05:02
Joined
Apr 9, 2015
Messages
4,337
You need an OUTER join query. One query to pull the items already there, qsPickedItems.
Then another query,that uses the query qsPickedItems, joined to the data table, but use an outer join to show all items in data table ,some items in qsPickedItems where the code isNull.
 

Users who are viewing this thread

Top Bottom