pop -up

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top