Filter Combo Box Dropdown Selection values based on data selected

[adityamoitra]

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.

 

[Ranman256]

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.