I have set up a form in access 2000 which allows you to select criteria in order to run a query. This is done via a series of combo boxes.
I want the query to pick up the criteria from the combo boxes which the user select but ignore the ones the user leaves empty.
In the query i am using the following criteria;
[Forms]![reportselectoractionsnl]![combo39]
(or) Like [Forms]![reportselectoractionsnl]![combo39] Is Null
At present I have two criteria to search on. When I put this expression in only one field in the query it works fine either the records selected via the combo box are displayed or if left blank all records are displayed. However when i add in the second criteria it always displays no records, unless both combo boxes are empty then it displays all records.
Any advice on where I am going wrong would be greatly appreciated.
I want the query to pick up the criteria from the combo boxes which the user select but ignore the ones the user leaves empty.
In the query i am using the following criteria;
[Forms]![reportselectoractionsnl]![combo39]
(or) Like [Forms]![reportselectoractionsnl]![combo39] Is Null
At present I have two criteria to search on. When I put this expression in only one field in the query it works fine either the records selected via the combo box are displayed or if left blank all records are displayed. However when i add in the second criteria it always displays no records, unless both combo boxes are empty then it displays all records.
Any advice on where I am going wrong would be greatly appreciated.