Hi all,
this post relates to the following topic, but when I tried to reply there, system said no… as it’s too old:
http://windowssecrets.com/forums/showthread//148254-Syntax-for-reference-to-parent-form-control
I have a form (fsubDossier) with two subforms I want to synchronise: fsubDossiers_Taakrapportering & fsubDossiers_Taakrapporteringdetail, both present at the main form as controls subDossier…
In the VBA code to synchronise (from the first subform’s on current event procedure), I refer to the second subform’s recordset using:
Me.Parent!fsubDossiers_Taakrapporteringdetail.Form.RecordSource
However, this raises an error… while exactly the same code referring to a third subform (…Partners) works fine.
I’ve been looking again and again (and again) in vain for the possible cause… maybe your eyes see more?
Any suggestions about what could be wrong here? Stripped database can be found in attachment…
Thanks in advance!
Hasse