I have a products form that lists the id,name, TOTALUNITS, CUSTOMERUNITS, OVERSTOCKUNITS, and SHOWROOM UNITS of an item.
there is a subform for that has where the current product is allocated to. ie customer name, po #, qty
basically i need the total fields to show the sums from the subform...