Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Syntax for reference to parent form control (2)

    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/sho...t-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
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    You don't have table tblTaakRapporteringDetail defined for the 2nd subfom.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts
    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...
    Last edited by hasse; 2015-04-24 at 05:10.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •