Nicolas, I believe part of the problem is the Trailing Grand Summary line in your layout. When editing an existing record or adding a new one, the Trailing Grand Summary line is hidden. When you click in an open space or go to Preview mode, the Trailing Grand Summary line reappears. The value is being recalculated, just not shown. Can you move your summary field to the body part? Steve Lemond Univ of Tennessee Martin 731-881-7895 From: FileMaker Pro Discussions [mailto:[log in to unmask]] On Behalf Of Nicholas Geti Sent: Saturday, June 05, 2010 9:01 PM To: [log in to unmask] Subject: How to recalculate when field changed I am using FMP v5.5 in Windows XP pro. How do I calculate the sum of a column everytime a user enters a change anywhere in that column? The layout is in browse mode and I am using a Trailing Grand Summary field. If I click on the Trailing field or enter Preview mode, the calculation happens. But I would like the layout to behave like a spreadsheet where all totals change when any item is changed.