I have a stock on hand form with lot numbers for each product which is connected to a sales order form. The S/O form has a combo box of which the user can choose the correct product/lot number to ship on each S/O. I have a query where the criteria states that once the quantity reaches zero, the product/lot number is removed from the stock on hand form. The problem is I cannot seem to remove it from the list in the combo box. Is this something that needs to be handled within the stock on hand table of course where the combo box was created from.
