I have a query that I'm trying to run from a form. Not only am I trying to run the query from a form but I'm trying to add query inputs from two different different drop down lists. Please take a look at the query parameters bleow. My query will run but it doesn't seem to recognize the values in the selected in the drop down lists. Does anyone know what might be going on? I don't have a lot of experience with Access but I really thought this would be a simple to do.
Criteria #1: [Forms]![ForProfit WWDS]![JobCode]
Criteria #2: [Forms]![ForProfit WWDS]![RevScope]
Criteria #1: [Forms]![ForProfit WWDS]![JobCode]
Criteria #2: [Forms]![ForProfit WWDS]![RevScope]