I would like to use multiple parameters query bound to text fields and combo boxes in a search form. I want to let the users to search for any value in their records by optional fields. I have used the classical way for filtering my data through this criteria [forms]![name of the form]![fieldname],but with no success. If I have used one criteria alone the query's working fine.
What is wrong with my query or what is wrong with me?
Please see attached a screenshot for my query, hopefully to understand what's going wrong here?
Thanks