Requery Subform two levels Down

I have a form which is two sub levels down

The top level form is "frmTabs"

The first sublevel is "frmTracking2"

The second sublevel is "frmProviderNo"

The forms data source for the above form is "tblProviderNo"

I want to requery the field "ProviderNo".

I have tried several forms for the expression - most recently:

" Docmd.Requery
Forms!frmTab.frmTracking2.Form!frmProviderNo!Provi derNo"

I get the error:
"Microsoft Access can't find the field 'frmProviderNo' referred to
in your expression"

Can someone give me the correct syntax?

Thx

On Thu, 29 Oct 2009 08:02:59 -0400, "kc-mass"
connearney_AT_comcast_DOT_net wrote:

The syntax is:
forms!myForm1!mySubformcontrol1.Form!mySubformcont rol2.Form!myControl

Note that I am referencing the subform control names; these can be
different from the SourceObject properties.

-Tom.
Microsoft Access MVP



I have a form which is two sub levels down

The top level form is "frmTabs"

The first sublevel is "frmTracking2"

The second sublevel is "frmProviderNo"

The forms data source for the above form is "tblProviderNo"

I want to requery the field "ProviderNo".

I have tried several forms for the expression - most recently:

" Docmd.Requery
Forms!frmTab.frmTracking2.Form!frmProviderNo!Prov iderNo"

I get the error:
"Microsoft Access can't find the field 'frmProviderNo' referred to
in your expression"

Can someone give me the correct syntax?

Thx

Thanks

"Tom van Stiphout" wrote in message
...
On Thu, 29 Oct 2009 08:02:59 -0400, "kc-mass"
connearney_AT_comcast_DOT_net wrote:

The syntax is:
forms!myForm1!mySubformcontrol1.Form!mySubformcont rol2.Form!myControl

Note that I am referencing the subform control names; these can be
different from the SourceObject properties.

-Tom.
Microsoft Access MVP



I have a form which is two sub levels down

The top level form is "frmTabs"

The first sublevel is "frmTracking2"

The second sublevel is "frmProviderNo"

The forms data source for the above form is "tblProviderNo"

I want to requery the field "ProviderNo".

I have tried several forms for the expression - most recently:

" Docmd.Requery
Forms!frmTab.frmTracking2.Form!frmProviderNo!Pro viderNo"

I get the error:
"Microsoft Access can't find the field 'frmProviderNo' referred to
in your expression"

Can someone give me the correct syntax?

Thx

If the control you want to requery is on the subform, I think you can just use:

Me.ProviderNo.Requery

You could put it in the subform's On Current event.

Hope that helps!



"kc-mass" wrote:

I have a form which is two sub levels down

The top level form is "frmTabs"

The first sublevel is "frmTracking2"

The second sublevel is "frmProviderNo"

The forms data source for the above form is "tblProviderNo"

I want to requery the field "ProviderNo".

I have tried several forms for the expression - most recently:

" Docmd.Requery
Forms!frmTab.frmTracking2.Form!frmProviderNo!Provi derNo"

I get the error:
"Microsoft Access can't find the field 'frmProviderNo' referred to
in your expression"

Can someone give me the correct syntax?

Thx



.