requery subform1 after data field updates in subform2

[SusanCoder]

I'm attempting to requery/reload a subfrm when a field on another subfrm is updated. I've not yet found the correct vba code. Thanks for your help.

I have three forms:

• frmYouthInfo - Youth's UniqueID, name and address fields, etc. (source data from query of tblYouthInfo)
• subfrmFunds - fields: DateOfService, Code, Amount. (source data from query of child table tblFunds, parent table tblYouthInfo, linked by the youth's UniqueID)
• subfrmMaxLifetimeDriversEd - fields: Code, SumOfAmount (source data from query of child table tblFunds where Code="52DriversEd", parent table tblYouthInfo, linked by the youth's UniqueID)

Both subfrms are on the same horizontal tab named Funds, located in the bottom portion of the frmYouthInfo. subfrmMaxLifetimeDriversEd will show the sum (SumOfAmount) of all entries on the subfrmFunds where code = "52DriversEd", so the staff can easily see when a youth has used their max funds in the Dorm category. I've created a few more subforms for Codes that have a max limit. I've attached a view of the forms as they are arranged.

The subfrmMaxLifetimeDriversEd is working, until the subfrmFunds is updated. Then I have to go out of the screen/form and come back in to force subfrmMaxLifetimeDriversEd to requery/reload. My goal is that when the Amount field on subfrmFunds (form on left bottom) updates, I want subfrmMaxLifeTimeDriversEd (subfrm on right bottom) to requery/reload.

Thanks, again, for your input.

[CJ_London]

if you are in subform1 and want to requery subform2 you would use

parent.subform2.requery

this will either go in your field afterupdate event or perhaps the subform's afterupdate event

[ssanfu]

You have to refer to the SUBFORM control name, not the subform name itself. ACCESS usually names the control the same as the object name.
So, if you have not renamed the subform control, in the after update event of the control "Amount" on the subform "subfrmFunds" you might try:

(Forms!MainFormName.subformName.Requery)

Forms!frmYouthInfo.subfrmMaxLifetimeDriversEd.Requery