When a record is being edited, pressing Esc once undoes the last change in a control, pressing Esc twice undoes the changes in the entire record. but the DSum on another text filed on the main form does update in 'real time' as expected.
I've met this problem on two dbs recently, and thought I'd check with the loungers...
Subforms are most commonly forms displayed as datasheets or continuous forms that show multiple records.
Queries and tables can also be used, and even forms in Form View.
If the link master field were Master ID which is an autonumber field and can't be edited, this would not be an issue.
However, if the field/control can be edited, it's critical that the Link Master Field uses the control name rather than the field name.
I was hoping a combination of recalc on the subform and a main form refresh would do the trick...
I can re-look to make sure what I think I'm doing is what I actually did , if you're of the mind that the two events should get me what I want.
A subform is a form with its own data source that is embedded in another "master" form.
From our sample database, open the form frm Editable Master: The form uses the table tbl Master as its Record Source: In the sample form, the field that's being used to link the subforms is the Editable ID, rather than the Master ID.
When you tab out of the control bound to the Date Recd field in the subform, the After Update event of the control occurs, but the record isn't saved yet, this occurs when you tab out of the subform record or save it explicitly.
So a recalc of the main form has no effect - the modified value of Date Recd hasn't been saved yet.
How the subform is defined does not matter but for this paper, we'll assume it's a form displayed as a datasheet.