How filter combobox based on another combobox on a form
Posted on 2016-10-20
I have two comboboxes on a form. The first one is named cboTYPE. Depending on the selection made in this combobox I want to filter the available choices in the 2nd combobox.
For example, if the user selects "Football" in the 1st combobox, then I want the option to select only "Brown" in the 2nd combobox. But if the user selects "Tennis Ball" in the 1st combobox then I want either "Yellow", "Green", or "Purple" to show up in the 2nd combobox.
How can I do this?