Form with multiple subforms RRS feed

  • Question

  • I am using a form that has 4 subforms inside of it.  Because not every subform is required, I have join types of 2 between the main table (which is corresponds to the main form) and to each of the tables the subforms are interested in.

    Because I have multiple subforms, when looking at recorded records through this main form view, I will see the same record several times, due to the fact that one of the subforms has multiple entries. 

    How do I filter or query for just unique ID's of the main form? 

    Monday, January 20, 2014 6:08 PM


  • There's no reason to create a query with joins to show form/subform data.

    In most subform scenarios, the underlying tables are in a One to Many relationship, with the main/parent form on the One side and subforms records on the Many side.

    Set each form/subform recordsource - independently - to the table that it pulls data from, then use the Link Master Fields and Link Child Fields properties in the Subform Control to create the link between the two (they're located under the Data properties tab when the subform control is selected).


    Jack D. Leach (Access MVP)
    Dymeng Services (home | blog)
    UtterAccess Wiki (hundreds of articles and functions)

    Monday, January 20, 2014 9:03 PM