• Syntax for reference to parent form control (2)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Syntax for reference to parent form control (2)

    Author
    Topic
    #499622

    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

    Viewing 1 reply thread
    Author
    Replies
    • #1501450

      You don’t have table tblTaakRapporteringDetail defined for the 2nd subfom.

    • #1501495

      Hi Patt, tx for looking into this. You are right (but) both subforms do use the same data source: tblTaakRapportering. The second subform is just another presentation.
      I try to emulate a split (sub)form…

      I should have made that more clear. I have reduced the original db maybe a little too thoroughly…

    Viewing 1 reply thread
    Reply To: Syntax for reference to parent form control (2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: