Auto email notification question.

[plasma]

I have an inventory database, and would like to know if there was any way to have a auto email notification when a specific item in a table is out of stock, or is low in quantity? I know who to do the auto notification when a form is created or modified, but I can't seem to figure out how to do this.

is it possible?

 

[plasma]

just thought of another question. would it be possible to have a pop up box come up stating something is low in quantity or out of stock? I would want this to happen when the database is opened.