SteveL13
asked on
How filter combobox based on another combobox on a form
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.