If I have the following code in an After Update Event in a field on a subform... this will refresh the subform with current focus as I expect...
Private Sub LaborCategory1_Hrs_AfterUpdate()
DoCmd.RunCommand acCmdRefresh
End Sub
...but what if I want to do the same thing - refresh a subform but instead of refreshing the subform under current focus... I would like to refresh a second subform. So if a user changes the field LaborCategory1_Hrs, after it's updated I would like it to trigger an automatic refresh of another subform. I'm not sure how to approach this. I sure would appreciate any ideas.
Thanks,
Lissa
Private Sub LaborCategory1_Hrs_AfterUpdate()
DoCmd.RunCommand acCmdRefresh
End Sub
...but what if I want to do the same thing - refresh a subform but instead of refreshing the subform under current focus... I would like to refresh a second subform. So if a user changes the field LaborCategory1_Hrs, after it's updated I would like it to trigger an automatic refresh of another subform. I'm not sure how to approach this. I sure would appreciate any ideas.
Thanks,
Lissa