Query using multiple parameters?
Posted on 2014-08-27
I want to run a query based on options selected in a drop down menu on a form.
I want the user to be able to pick what parameters he/she will use.
However, the query will only run based on 1 of the parameters I have set up and won't run on the others.
My form has the following combo boxes: cmbTeam, cmbTO, and cmbSTO.
I have the query set up so that, in the query builder under the field, it says "[forms]![frm_ParameterRpt]![cmbTeam] or like [forms]![frm_ParameterRpt]![cmbTeam] is null"
I have that for each field I want the user to be able to filter by.
However, something weird is happening.
When I set this up the first time, I put the "[forms]![......" in the cmbSTO field first. I set up the parameters for the other fields, but the query will only run for the cmbSTO parameter.
I reset everything up, but put the parameter in for cmbTeam first. Even though all the other parameters are listed, it will only run the query for cmbTeam.
I am really confused. Does someone know what is going on?
And, I apologize if my wording is super poor. I am happy to explain further.