title: Access 2007 Filter Subform Based On Field In Main Form?
body: <p>I was tasked with creating a simple app to maintain a user's collectibles collection using Access 2007. There were some requests, which I have created and implemented. Those being:</p>
  
  <ol>
  <li>One main form listing all of his collectibles</li>
  <li>That same main form has a tabbed control below, with each tab containing a subform that in effect "filters" data based on different criteria from the main form. For example, the 1st subform takes the name of the collectible figure in the main form, and displays all other records using that name in the subform. In other words, if the figure is "Darth Vader", the subform would list all collectibles that have the name "Darth Vader".</li>
  </ol>
  
  <p>I have created the application as per user request, but there is one thing that is bothering both of us so far. The subform's first record is the same as the main form. We both find that redundant, and annoying. Granted, my Access skills is weak at best, so this may be a simple fix, but is there a way to remove the duplicate record in the subform? I have tried implementing a where clause in the subform stating to not include the "Figure ID" in the main form. Problem is, it is acting like a Parameter prompt, asking for the main form's FigureID when I open the subform, or the main form. If I type in the Figure ID, it works, but the prompt is something that is obviously not wanted.</p>
  
  <p>FYI: </p>
  
  <ol>
  <li>The main form is based on a query that basically selects all records from the "Figures" table and other related tables</li>
  <li>The subform was created when I dropped the subform control onto the tab control, where I linked the necessary master and child fields</li>
  </ol>