Forum Discussion
RJF61
Feb 16, 2023Copper Contributor
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 fie...
arnel_gp
Feb 16, 2023Iron Contributor
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
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
- RJF61Feb 17, 2023Copper ContributorThanks for the response. So the code should be installed in the Event portion of the Subform "sfrmEMES"?