I have the following code
I would like to add a clause which would say
which is like saying that if you leave the categoryID
blank then you will get all suppliers as shown in
Combo0.
Needless to say my attempt above didn't work.
Any help greatly appreciated
PHP:
Dim strSQL As String
strSQL = "SELECT * " _
& "FROM tblProducts " _
& "WHERE (((tblProducts.SupplierID)=" & Combo0 & ") " _
& "AND ((tblProducts.CategoryID)=" & Combo3 & "));"
I would like to add a clause which would say
PHP:
OR
WHERE (((tblProducts.SupplierID)=" & Combo0 & ") " _
& "AND " & Combo3 IsNull);"
which is like saying that if you leave the categoryID
blank then you will get all suppliers as shown in
Combo0.
Needless to say my attempt above didn't work.
Any help greatly appreciated