Requerying a subform from another subform

  • Thread starter Thread starter Glenn Suggs
  • Start date Start date
G

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.
 
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.
 
Thanks Douglas,
I overlooked the difference in the name of the subform vs. the name of the
subform control.
--
Glenn


Douglas J. Steele said:
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!)


Glenn Suggs said:
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.
 
Back
Top