Forum Discussion
Cascading combos, filtering or something else
Hi all Hoping for some advice or to be pointed to the correct terminology so I can research further. I have a table of equipment, each of which can have multiple suppliers and also have multiple...
Aaron1040
The good news is that what you describe is a fairly common requirement and there is, in fact, an established method for handling it. It is commonly referred to as "Cascading Comboboxes". The "upsteam" control (which is usually a combobox, but could be a listbox) is based on the higher level category. The "downstream" control (again, combo or list box) is based on the lower level category and it is FILTERED by a selection made in the upstream control. The after update event of the upstream control is used to apply that filter to its downstream partner.
Searching on the term cascading combobox should turn up a plenitude of discussions and examples.