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

Place the VBA code in the after update event for the "quantity for an item".

Steps:

• Get the quantity on hand ( probably by opening a recordset)
• See if quantity requested > quantity on hand
• display a message is true