i have a form that i'm creating that is attached to an Access database. I have 2 drop down boxes to control a query. One ddl allows the user to select a department and the other allows the user to select the role. i want the user to be able to choose multiple departments and multiple roles to query. i was thinking of making multiple optional sections with the same controls in each section. however, when i select a department in the first section it sets the value in all sections. How do I set it up so that each section adds a new department to the query and the results show all selected departments and roles? Do I need to use an expression box or a formula?