Forum Discussion

RJF61's avatar
RJF61
Copper Contributor
Feb 17, 2023

Subform Refresh When Main Form Opened

I have a Main Form "frmProjQry" that contains (6) subforms.  One of the subforms, "sfrmEMES" is not refreshing so summary data (from sfrmEMES) is not updating in a Main Form Text Box.  Other subforms with similar processes do refresh and update their related Text Box.  I do have the following...

As shown, when the Main Form is opened, the subform is not refreshed with data.  The sum of the EMESCst field is then not calculated and transferred to the location shown.  This field is also needed for a report (that is not functioning correctly) due to the empty value. 

Is the issue possibly related to when the requery's are run?

2013
2016
access
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Feb 18, 2023
    Subforms load before the form in which they are embedded. That means the subform, sfrmEMES, which has already loaded when the main form is loaded, will not reflect the value of the text box on the main form.

    Why do you requery only four of the six subforms?

Resources