S
Sprinks
In a data entry subform resembling a spreadsheet, I have summary fields in
the footer whose control source is set to =Sum([Field1]), =Sum([Field2]),
etc., looking much like any spreadsheet would.
Without any code, the totals only update if I move to a new subform record.
If I force recalculation with Me.Recalc, all calculated controls "blink",
even if their value has not changed. An MVP suggested recalculating only the
affected control with Me.Field1.Recalc, but this triggers a "Method or data
member not found." error, and Help suggests that the Recalc method applies
only to the Form object.
I tried creating a Totals query, and embedding it on the main form, then on
the subform itself, both without success.
I'd like the form to look and feel like a spreadsheet--when a value changes,
the affected "cells" change but the others remain still.
Can anyone help?
Thanks. Sprinks
the footer whose control source is set to =Sum([Field1]), =Sum([Field2]),
etc., looking much like any spreadsheet would.
Without any code, the totals only update if I move to a new subform record.
If I force recalculation with Me.Recalc, all calculated controls "blink",
even if their value has not changed. An MVP suggested recalculating only the
affected control with Me.Field1.Recalc, but this triggers a "Method or data
member not found." error, and Help suggests that the Recalc method applies
only to the Form object.
I tried creating a Totals query, and embedding it on the main form, then on
the subform itself, both without success.
I'd like the form to look and feel like a spreadsheet--when a value changes,
the affected "cells" change but the others remain still.
Can anyone help?
Thanks. Sprinks