I have a simple sub form which displays only a few records of dataset. It also has a simple sum of one of the fields “=sum([Fee])” in the form footer.
In Access 2003 the sum was always calculated and visible. Now in 2010 the sum is only visible if the last record is displayed in the scrolling region. For example if my dataset contains 35 records, and I am only displaying 3 records, I have to click the "Last Record" navigation button in order to finally get the sum to calculate and display.
I need the sum to calculate and display immediately upon my form rendering.
There must be a new property that I am unfamiliar with in 2010 that will allow me to adjust for this.