Control

[Guest]

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?

 

[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?

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]