Log In    |    Knowledge Base    |    4D Home
Tech Tip: Generating the Sum for records in a subform
Published On: May 21, 1999
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

This tech tip covers the easiest way of generating the Sum of the records in a subform. Assume that a database had the tables listed below and the Invoices input form has a subform for Invoice_Items. In this input form, Invoice_Total would contain a sum of Item_Price for all the records in the subform.

The sum needs to be updated when a value is changed in Item_Price and when a record is deleted in the subform. To update the sum when a record is changed in Item_Price, the following code needs to be executed:

To update the sum for when a record is deleted, execute the following code in the button that deletes the record:

Notice the 2nd code example subtracts Item_Price from the sum. This is because this code will get executed before the record is deleted.