abenitez77
Registered User.
- Local time
- Today, 13:34
- Joined
- Apr 29, 2010
- Messages
- 141
I want to set the recordsource on a GrandChild form:
I tried these 2 ways and i get the error msg: "Run-Time error '2467': The expression you entered refers to an object that is closed or doesn't exist.
I have the code below in the OnChange of the CurrentForm (this is the 1st subform)
Forms(Mainform)(CurrentForm)(SubFormNew).Form.RecordSource = "Dyn_" & project_id & "_SubQryTab05"
Forms!Dyn_163_Workspace!Dyn_163_SubFrmTab05Sec.Form!Dyn_163_SubFrmTab05.Form.RecordSource = "Dyn_" & project_id & "_SubQryTab05"
I tried these 2 ways and i get the error msg: "Run-Time error '2467': The expression you entered refers to an object that is closed or doesn't exist.
I have the code below in the OnChange of the CurrentForm (this is the 1st subform)
Forms(Mainform)(CurrentForm)(SubFormNew).Form.RecordSource = "Dyn_" & project_id & "_SubQryTab05"
Forms!Dyn_163_Workspace!Dyn_163_SubFrmTab05Sec.Form!Dyn_163_SubFrmTab05.Form.RecordSource = "Dyn_" & project_id & "_SubQryTab05"