I am doing an Invoice database; I have a form that works great, it has a subform that looks up the products. I would like to be able to use the drop-down field in the sub form so that if it teh Status column has "In stock" the total price will equal "Quanity*UnitPrice" other wise "Total Unit Price" will equal $0.00.
Can I do a statement like:
= If Status = "In Stock" then
Total_Unit_Price = Quantity*UnitPrice
Else Total Unit Price = "0"
End If
If I can do this where would I do it and how?