I have a subform in which I enter the [Order Intake Value] per [Year] for a [Product] (Main form is products form and subform has values) I have another subform based on a query which is SUM([Order Intake Value]) for a given [Product] How can I get this SUM([Order Intake Value]) field to update immediately after I update the [Order Intake Value] field i.e. without having to close and then reopen the main form?

Try Me.Recalc

I'm not sure what you mean. Where do I use it. How do I use it with the control

Use the AfterUpdate event for the [Order Intake Value] field. Just put Me.Recalc between the open and close of the subroutine (in Code Builder...it's not scary)

HTH,
David R