Control

A

Antonio

Hello I'm greating an inventory database and I have a problem with what I
have sold exceeding my total inventory. How can I stop the sold items from
exceeding the inventory?
 
J

John Vinson

Hello I'm greating an inventory database and I have a problem with what I
have sold exceeding my total inventory. How can I stop the sold items from
exceeding the inventory?
Click to expand...

Probably by putting VBA code on the BeforeUpdate of the form whereupon
you enter sales; this should check the amount sold against the
inventory; post a message to the user using MsgBox and set the Cancel
parameter of the BeforeUpdate() call to True.

John W. Vinson[MVP]
 
Top