I am doing a Printer inventory and have two columns, type of cartridge and
the quantity. What I would like to do is when the quantity of each cartridge
goes below 3 when exiting, every time, a pop up warning “Inc is low for
cartridge X. Order more “shows up. So far I have it giving a pop up that
tells when the quantity is low, but want I really want it to do is tell the
type of cartridge that is low at every exit. Can this be done? What would
the coding look like? this what works now

Private Sub Quantity_AfterUpdate()
If Me.Quantity <= 3 Then
     MsgBox "Printer Inc is low. Order more Inc!"
End If
   
End Sub
 
This is the info, so if HP -10 go under 3 in the inventory a pop up will say
"HP-10 Inc is low. Order more Inc" and it will give the pop -up every time at
exit until the inventory is incressed over 3.
Type of Cartridge    Quantity
HP - 10                       2
HP - 15                       6
Can anyone show me how to get this done?

Thanks

Toolz