Still Struggling with another Dlookup for multiple criteria.
My current code which works is
and i want to add another criteria to check if the supplier is live, so tried this code which does not work.
The live field is in the same table "TblQCPreRetailSuppliers" and is a yes / no field. (Tick Box)
Do i need to have the field on the Form to look up if they are live or not ?
My current code which works is
Code:
WhoCharge = Nz(DLookup("Processor", "TblQCPreRetailSuppliers", "Supp_Code='" & Nz(tbSup_Code.Value, "") & "'"), "")
and i want to add another criteria to check if the supplier is live, so tried this code which does not work.
Code:
WhoCharge = Nz(DLookup("Processor", "TblQCPreRetailSuppliers", "Supp_Code='" & Nz(tbSup_Code.Value, "") & "' AND [Live] = True"), "")
The live field is in the same table "TblQCPreRetailSuppliers" and is a yes / no field. (Tick Box)
Do i need to have the field on the Form to look up if they are live or not ?