Update Main form after Updating Subform

[Dougalsworld]

Hi All,

I'm sure there is a simple solution to this problem but I just can't find it, and looking on this forum i can find several ways to refresh the subform but not the main

I have a Form and a subform (frmMaster and sub_Paid)
on the subform, sub_Paid I have a field called dblPaidValue this is used to calculate a field in the main form txtPaidTotal.

When I open the main form the calculation works fine, but if I update the field on the subform, the calculation does not update...I've tried multiple variations of Recalcs...Refreshes and Requeries to no avail, can anyone help?

Kind regards
Paul

 

[jdraw]

Suggest you post the code you are using.