I have a form based on a query. It contains PartID_PK, PartName, QtyPurchased, QtyUsed, QtyOnHand, LowLimit. I would like to create a message box with a warning anytime the the number in qtyOnHand drops below the number in LowLimit. How is this done?
Thank you all for your assistance.
Michael