I have a subform that holds information for a PO database. It has qty, unitprice, description and Amount. Amount is the total of qty * unitprice. Is there a way on the main form to get a textbox named totalamount to display the sum of the amount from the subform. So if the sub has 2 records totaling 70 dollars, the total amount control on the main fomr displays it. Thanks in advance for any hlp.

yes. just create another textbox and type the following inside the textbox itself on the subform:

=NZ(qty)*NZ(unitprice)
let's say that this textbox name is "totalamount".

The NZ creates a value of 0 if any of the two textboxes is null.

Create another textbox on the footer of the subform Let's say you call it "grandtotal" and type the following inside of the textbox:

=Sum(totalamount)

Then set it to hidden (no need to do it if you are showing it as datasheet). Then open the main form and create another textbox and use the expression builder to give it the value of "grandtotal" of your subform.





Sal