Forum Discussion

RJF61's avatar
RJF61
Copper Contributor
Feb 16, 2023

Form/Subform Information Update

I have an Access DBF where a form is based on a table tblProj.  In this form I have multiple subforms related to the table based on a field "WONumber".  When the form initially opens, some of the fields populate as shown.  However the field in the red box does not populate (contents: =[sfrmEMES]![TotEMESCst]. 

If I move to the next record and return, the field does populate with an accurate value.

I have the following but frankly haven't looked at it for so long I'm rusty.

  Is there something I should change so that the field populates when opened?  

 

 

2013
2016
access
developer

2 Replies

  • arnel_gp's avatar
    arnel_gp
    Iron Contributor
    Feb 16, 2023
    maybe you can add Timer event to the subform in question.
    Set the timerInterval = 60.
    the timer event:

    Private Sub Form_Timer()
    ' instantly kill the timer event
    Me.TimerInterval = 0
    ' requery the other subforms
    Call Form_Current
    End Sub


    • RJF61's avatar
      RJF61
      Copper Contributor
      Feb 17, 2023
      Thanks for the response. So the code should be installed in the Event portion of the Subform "sfrmEMES"?

Resources