I am trying to use DCount to look for duplicate orders in a table, but even when there is one, it ignores it.
Code:
If DCount("*", "WOTracking", "OrderNo='" & Me.tbxOrderNo & "' AND SKU='" & Me.tbxProductSKU & "'") >= 1 Then
Likewise, I am trying to use DLookup to check quantity on two items but it is either returning a Null value or is not even functioning (though it is not throwing any errors).
Code:
If DLookup("Inventory.SaleableQty", "Inventory", "Inventory.SKU = '" & Me.cbxSKU & "'") >= Me.tbxSKUQty And DLookup("Inventory.SaleableQty", "Inventory", "Inventory.SKU = '" & Me.cbxNamePlate & "'") >= Me.cbxNamePlate Then
With no error, I am stump. Anyone see something that I am missing?