Requerying a subform from another subform

[Glenn Suggs]

I need to requery (refresh?) a subform from another subform on the SAME main
form. This syntax in the first subform doesn't seem to work.

[Forms]![frm_Main_Form].[subfrm_Second_Subform].Form.Requery

Can anyone help? Thanks in advance.

 

[Douglas J. Steele]

Are you sure that the name of the subform control on the parent form is
subfrm_Second_Subform? Depending on how the form was added as a subform, the
name of the subform control may be different than the name of the form being
used as a subform.

 

[Glenn Suggs]

Thanks Douglas,
I overlooked the difference in the name of the subform vs. the name of the
subform control.
--
Glenn

Are you sure that the name of the subform control on the parent form is
subfrm_Second_Subform? Depending on how the form was added as a subform, the
name of the subform control may be different than the name of the form being
used as a subform.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I need to requery (refresh?) a subform from another subform on the SAME
main
form. This syntax in the first subform doesn't seem to work.

[Forms]![frm_Main_Form].[subfrm_Second_Subform].Form.Requery

Can anyone help? Thanks in advance.