DSum calculation on main form from a subform DLookup field.
Posted on 2008-06-23
What I'm trying to do here is create a sum calculation that would total up all of the prices from the 'Price' field in the subform. The only problem is, the prices on the sub form are currently being populated using the DLookup statement. So, when a part is entered into the subform, the corresponding price is 'looked up' and displayed in a text box next to the part number. What I want to do is have a text box on the main form (frmTestView) calculate all of these DLookup prices that appear on the sub form. What would be the best way to go about calculating the Price field in this sub form?