Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010

    Unanswered: How to filter displayed subform data?


    I am trying to make a form using the following tables:

    TechSmith |, online video sharing, Access form setup 2011-01-03_0243

    I can create a form from the "Website" table and my "history" table will show up as a sub-form. This is what I want, because the history table is meant for storing notes

    However, a 3rd table, not pictured, is used to make a query with the website table which I then build a form from. No subform is created by default (bad) When I try to add a history table subform, the history data is not filtered against the currently displayed entry.

    I know what the problem is: the subform is not filtering the data it displays based on the entry data. My question is, how can I get the sub-form data to link with the displayed entry?


  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    As answered elsewhere:

    In the properties of the subform control on the main form (not the subform itself), you'll see Master/Child link properties.

  3. #3
    Join Date
    Oct 2010

    Working with issues

    I have linked the matching field (in this case the website ID) However only one entry is now shown in the main form.

    TechSmith |, online video sharing, Missing form.subform entries 2011-01-03_1813

    The main form had 3 entries. the Subform has matching entries for each.

    Any idea why the main form is showing only one entry?


Posting Permissions

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