Good Afternoon All:
I have what I hope is a quick question concerning using DCount to determine if a record exists. I have the following
but am getting a Data Type Mismatch error on the DCount line.Code:If DCount("*", "[Inventory]", "[SKU] = " & Me.tbxProductSKU) > 0 Then strUpdateQtySQL = "UPDATE Inventory SET Quantity = Quantity -" & Me.tbxSKUQty & " WHERE SKU = " & Me.tbxProductSKU & ";" End If