Unanswered: Return All/Selected Records with two Combo Boxes
I have a form that using two combo box to select specific record or all records.
I would like if the combo box if left empty, in any of them, it displays all the records.
When I used both the combo box as filled or as empty, it is perfectly working but when I opt one combo box as filled and another as empty, no records are showing.
Following is the Query, which I am using for the above:
SELECT Contract.ContractNo, Contract.Supplierid, Contract.Itemid
WHERE (((Contract.Supplierid)=[Forms]![Form]![Selectparty]) AND ((Contract.Itemid)=[Forms]![Form]![Selectitem])) OR ((([Forms]![Form]![Selectitem]) Is Null) AND (([Forms]![Form]![Selectparty]) Is Null))
ORDER BY Contract.ContractNo DESC;