Hi, in my inventory I have the following field
ProdName.
UnitCost.
QtySold.
TotalCost
Remaining Quantity
As you are selling product the Remaining Quantity is reducing. But when the product is finished it turn to Zero. The problem am having now is that if I enter a value e.g 20 in the field of a 'QtySold' the 'Remaining Quantity' changes to -20.
This is the code for the "Remaining Quantity"
=IIf(IsNull([Product_Id]),0,DLookUp("[Product_Quantity]","qryProduct_Quantities","[Product_Id] = " & [Product_Id]))
What I want now is that if my Remaining Quantity is 0, TotalCost=0 when QtySold*UnitCost are multiplied or a message should pop-up and say Product Finshed. I really needs help. Thanks for your usual assistance