T
Toolz2life
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
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