How to flag a warning

[SamCrow]

Hey guys,

I'm still a bit new to microsoft access as I am still learning.
I have a customer related database and I want to make a warning window when the customer enters a quantity that is greater than the quantity on hand.
So if there are 150 kitkats on hand, and the customer enters >150 then it will give me a warning sign.

Is there a way that I can do that?



Thanks

[Bob Fitz]

How will you calculate the "quantity on hand".

[SamCrow]

I subtract the Quantity on hand from the Quantity that the customer wants.
So it is as follows: Quantity on Hand: [Qty]-[Quantity]
That's how my entities are named.

[Bob Fitz]

You will need some code in the Before Update event of the control in which the user enters the qty. If the user is trying to enter a figure greater than the quantity in hand, the event can be cancelled wth:
Cancel = True
which you could follow with a line to inform the user:
Msgbox "Please enter a quantity that is equal to, or less than the quantity in hand."