falcondeer
Registered User.
- Local time
- Today, 08:28
- Joined
- May 12, 2013
- Messages
- 101
Hi everybody
I created this query (pic-3) to count down the quantity of any prescribed item and it is working fine and updating the table (pic-1)
Now what I want is this:
When the user want to update the quantity combobox (pic2), I want to show him/her a message box saying either "There is enough stock or not" based on the number in ItemCurrentStock field (pic-1), So they either proceed with the request or stop it. I do not want to show them the whole table (pic-1) though.
How can I do that.
Thanks
I created this query (pic-3) to count down the quantity of any prescribed item and it is working fine and updating the table (pic-1)
Now what I want is this:
When the user want to update the quantity combobox (pic2), I want to show him/her a message box saying either "There is enough stock or not" based on the number in ItemCurrentStock field (pic-1), So they either proceed with the request or stop it. I do not want to show them the whole table (pic-1) though.
How can I do that.
Thanks