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.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!