If the total stock is reach 1 means it generate alarm or msg

  • Thread starter Thread starter prabhu
  • Start date Start date
P

prabhu

Hi everybody i prepared a simple DB for my stocks.If the total stock is reach
1 means the computer gives an alaram(or)msg when i open the database or that
stock table
 
Hi everybody i prepared a simple DB for my stocks.If the total stock is reach
1 means the computer gives an alaram(or)msg when i open the database or that
stock table
Click to expand...

what about in the AfterInsert of your form? You could grab the
StockNumber, and use Allen Browne's QuantityOnHand calculation, and
return the value somewhere. Then if it's less than your threshhold,
pop up a messagebox or write to a table or whatever. The solution is
on his website. www.allenbrowne.com
 
Back
Top