Aug 1 2005, 02:46 PM
When i fill out the purchase requisition and change the quantity for an item, i want it to check the quantity we have on hand in my products table to see if the quantity requested is available and if not display a popup box saying "Item # so and so has only # in stock". Thanks
Aug 1 2005, 06:37 PM
Place the VBA code in the after update event for the "quantity for an item".
- Get the quantity on hand ( probably by opening a recordset)
- See if quantity requested > quantity on hand
- display a message is true