I have set up a form PPE Disbursement  for our inventory that has a subform to enter quantities used and quantities returned.  The amounts entered in the subform update our quantity on hand in another form called Add PPE.  This Add PPE holds the fields PPE Description, PPE category, Total on Hand, and Inventory Reorder Level.   

We will use Add PPE to update records when an inventory count is completed.  I have been able to set up so that an email notification is sent  when this form is edited and the Total on Hand goes below the inventory level.

Normal routine is from another form, items are disbursed or returned using a subform (Single Item PPE) for multiple item entries.  This also updates the Total on Hand In for Add PPE. 

When the disbursement form is  submitted and the Total on hand is updated I want a notification to be sent when the levels reach a specific quantity.  I thought the update from the subform would trigger the notification but it doesn't.  How can I get this to work.  I'm not a programmer so it is gettling a little frustrating.  Any help would be gratly appreciated