Requery a subform using a variable (1 Viewer)

[Trocergian]

I'm attempting to requery a subform using a variable and running into "can't find form" errors.

Here's code that works fine when run directly:
Forms!frmDashboard!frmDwgStatusSub.Form.Requery

But when loaded into a variable and trying to run via:
Forms(gSendingForm).Requery
throws an error.

I've attempted:
gSendingForm = "Forms!frmDashboard!frmDwgStatusSub.Form"
and
gSendingForm = "frmDashboard!frmDwgStatusSub.Form"
and
gSendingForm = "frmDashboard!frmDwgStatusSub"
with no luck.

I can use Forms(gSendingForm).Requery (ex. gSendingForm = "frmDashboard") to requery any top level form so I'm guessing that command is not the problem.

What am I missing?

 

[GohDiamond]

Addressing a field on a subform
Forms!Mainform!Subform1.Form!ControlName


Here's a bookmark for you for future reference:
http://access.mvps.org/access/forms/frm0031.htm

Cheers
Goh

 

[sneuberg]

You can do it like:

Forms("NameOfMainForm").Controls("NameOfSubformControl").Form.Requery

where the strings "NameOfMainForm" and "NameOfSubformControl" could be replace by string variables.

Forms("NameOfMainForm")("NameOfSubformControl").Form.Requery

works too. And in the forms module just

Me("NameOfSubformControl").Form.Requery