I have an Access db with an Invoice form that also had a detail subform. The Invoice is an order form and the detail subform lists: quantity, description item ordered, and the inventory in stock for that item. I have a cmd button that activates a module that is to update the inventory. It is to find the description item ordered in the inventory table and subtract the quantity ordered from the stock. I cannot get the code to find the subform no matter how I type it. How do you code VBA in order to find fields in a subform?