Enabling only certain options to appear in a combo box contingent on what was selected in another

[nick404]

I have two combo boxes. One is a "Commodity" box where the user selected, for brevity, either commodity a, b, c, or d. They then select from the "Non Conformance" combo what type of error occurred with that commodity during production (1a, 2a, 3a, 1b, 1c, 1d, &c). However, some non conformance errors will occur only to one or two commodities and not to others. For simplicity on the front end, I would like to allow for only certain options to appear when the user selects a certain commodity. For example, only options 1b and 2b will appear in the "Non Conformance" combo box when the user selects Commodity b from the "Commodity" combo box. See the picture below. All help appreciated.

[ItsMe]

It seems you want cascading comboboxes. Here is an overview of what I am talking about.
http://www.datapigtechnologies.com/f...combobox2.html

And here is their main menu for their other tutorials
http://www.datapigtechnologies.com/AccessMain.htm

I created a series abut the Combobox too. This series starts with the properties of the combo and goes on from there. The details how to download these videos is here ...
https://www.accessforums.net/tutoria...ers-52741.html

[nick404]

That should work out perfectly once I get it going. In order for me to do this do you think I will need to have a separate table that contains just commodities and non conformance types? And then use that table as the row source for the comboboxes?

[June7]

Yes, need a table that associates commodities with their possible errors.