J
JMCS
After several frustrating hours, please can I have some help with this one.
I have two sub-forms on separate tabs of a main form; the first sub-form
contains 48 calculated fields at a summary level (summary project), whilst
the second contains 48 detail fields (projects). When the detail fields in
the second form are updated, I have been able to get the underlying records
updated before moving to the summary sub-form. However, I cannot get the
summary sub-form to display the amended totals unless I move to another
summary record and return. I can get the form to update if I simply click on
"Records - Refresh", but I want to make it happen automatically WITHOUT
extensive programming steps (ie refresh each of the individual fields
separately.
Thanking you in anticipation...
I have two sub-forms on separate tabs of a main form; the first sub-form
contains 48 calculated fields at a summary level (summary project), whilst
the second contains 48 detail fields (projects). When the detail fields in
the second form are updated, I have been able to get the underlying records
updated before moving to the summary sub-form. However, I cannot get the
summary sub-form to display the amended totals unless I move to another
summary record and return. I can get the form to update if I simply click on
"Records - Refresh", but I want to make it happen automatically WITHOUT
extensive programming steps (ie refresh each of the individual fields
separately.
Thanking you in anticipation...