If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Requery Subform two levels Down
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 |
#3
|
|||
|
|||
Requery Subform two levels Down
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 |
#4
|
|||
|
|||
Requery Subform two levels Down
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 . |
Thread Tools | |
Display Modes | |
|
|