From: Dan E. Dan on
Using Access 2007, I have a sum expression in the footer of a subform to
total the values of a field in all of the records in the detail section.
When the database is opened by a new computer running Windows 7 the sum
expression will not recalculate changes made to records in the detail section
unless "refresh all" is executed. The sum recalculates changes to the
database automatically when opened by other computers using older versions of
windows. Is this a problem being caused by Windows 7 or just a setting I
have missed in Access on the new computer?