Refresh or requery subfrm from the AfterUpdate event of another subform's field

[SusanCoder]

Thanks for your help with the syntax for a refresh or requery a subfrm after a separate subform field has been updated. I tried the following code without success.

 Private Sub Amount_AfterUpdate()
          Me.[OKIL Main Screen]!subfrmFundOneTimeDriverEd.Form.Requery
End Sub

Run-time error ‘2465’: Microsoft Access can’t find the field ‘|1’ referred to in your expression.

master form name = OKIL Main Screen (Inherited name, did not name! lol)
2 child subforms' names = FundsSubTable (again, did not name) and subfrmFundOneTimeDriverEd.

The subforms each have a master/child relationship with the master form through the UniqueID field (client’s UniqueID).



Subform FundsSubTable records funds requests for a client (UniqueID) by DateOfService, Code, Amount.
SubfrmFundOneTimeDriverEd's shows the results for the client (UniqueID) of the sum of Amount for each Code.

In the After Update event for FundsSubTable.Code, I want to re-run the query (or refresh the form) for subfrmFundOneTimeDriverEd, so that the sums are updated after a user makes a change to the FundsSubTable.Amount.

Thanks, again, for assistance.

[andy49]

http://www.techrepublic.com/blog/mic...ubform-107106/

You're referencing the subforms wrongly


Sent from my iPhone using Tapatalk

[SusanCoder]

Thanks, andy49.

I took your advice and changed the syntax suggested by the article from your link. I didn't get an error message, but changing the amount didn't change the sum in the other subform.

Forms!mainform.Form.subform.controlonsubform

[code]Private Sub Amount_AfterUpdate()
Forms![OKIL Main Screen].Form.subfrmFundOneTimeDriverEd.Requery
End Sub [/code]

[HiTechCoach]

SusanCoder,

You are using the after update event of a control which fires BEFORE the record has been saved. The change is still in the " record buffer". You must save the record before other forms can see the change to the record.

I would use the form's After update event to requery other forms.

Private Sub Amount_AfterUpdate() 

     Me.Dirty = False ' save the record

End Sub

In the form's After Update event

Private Sub Form_AfterUpdate() 

' now the record has been saved, update the sub form
   Forms![OKIL Main Screen].Form.subfrmFundOneTimeDriverEd.Requery


End Sub

[SusanCoder]

HiTechCoach, you are a rock star. Your solution worked! I appreciate your explanation along with the code because it helped me learn. Can't thank you enough.

For future reference for those looking at this solution: I added Me.Dirty=False to the AfterUpdate event on the Amount control in the form FundsSubTable, and added the requery statement Forms![OKIL Main Screen].Form.subfrmFundOneTimeDriverEd.Requery to the form FundsSubTable's AfterUpdate event.

[HiTechCoach]

You're welcome. Glad we could assist.

And thank you for "paying it forward" by sharing your solution so other may benefit.