+ Reply to Thread
Results 1 to 3 of 3

Thread: Master/Child between Subforms

  1. #1
    Registered User
    Join Date
    01-07-2008
    Posts
    65

    Master/Child between Subforms

    Let’s say that A is the mainform. B and C are subforms each within A. Neither B nor C are subforms within the other. Is it possible to create a Master/Child relationship in which a field within B is the Master and a field within C is the child?

    If so, is it possible to accomplish this if both B and C are displayed in Datasheet view?

    Thanks,

    Justin
    Last edited by pilotwings64; 08-20-2010 at 09:46 PM.

  2. #2
    Registered User
    Join Date
    01-07-2008
    Posts
    65

    Re: Master/Child between Subforms

    GalaxiomAtHome from Microsoft Access Help Center (http://www.access-programmers.co.uk/forums) offered this solution.

    “Place a textbox on the mainform with the control source as the subform field you want as the Master (=Forms!mainform.subformB.Form.fieldname). Then set this textbox as the MasterLinkField of the other subform control.”

    I tried, this and it linked the text box to the desired field in subform B but I can’t find a way to link subform C to that text box using a master/child relationship.

    Does anyone know how I can complete this final step?

    Thanks again,
    Justin

  3. #3
    Registered User
    Join Date
    01-07-2008
    Posts
    65

    Re: Master/Child between Subforms

    mike60smart at UtterAccess.com walked me through the process. The thread has the same name as this one (maybe I named it Parent/... instead of Master/...).

    Basically, I just had to do the master/child linking in the properties panel, by tying the links in, since the dialog box and dropdown menu were not offering me the option.

    Hope this helps anyone with the same problem.

    Justin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0