I'm working on a simple database that will be presented used internally to perform a simple filter operation on the entire recordset based on selections made from two combo boxes. I've got the first part figured out, but I'm drawing a blank on the filtering component. I'm looking for the most efficient way to achieve this.
The workflow should go as follows:
- User selects an industry from the Industry combo box (this filters the second box)
- User selects sub-industry from Sub-Industry combo box
At this point - a subform/query should return the results that correspond to the selection made in the combo boxes from the table breachArticleInfo.
As always - I appreciate the time!