title: Requery subform from another subform, problems
body: <p>I have 2 subforms on the main form. Sub_2 displays the details for the item chosen in sub_1, in a list. For both subform, I use the continue form, and they are bounded to 2 querys, with one field in common, say 'id'.</p>
  
  <p>What I have done is adding code in the DClick event on sub_1 to set the sub_2's filter like</p>
  
  <pre><code>Me.Parent.sub_2.Form.Filter = "id=" &amp; "'" &amp; Me.Recordset!id &amp; "'"
  </code></pre>
  
  <p>Then a requery</p>
  
  <pre><code>Me.Parent.sub_2.Form.Requery
  </code></pre>
  
  <p>But no luck, when I double click the record in sub_1, no change in sub_2. I have had a look on relevant questions, I think this should work... </p>
  
  <p>Any suggestions? Maybe I should use other approach to do this?</p>
  
  <p>PS: I'm sure <code>Me.Parent.sub_2.Filter</code> is changed, but requery doesn't work.</p>
  
  <p>EDIT:</p>
  
  <p>Thanks for answers. I find the problem, that is, the 'id' field is in the query, but it's not displayed on the subform, so maybe Access cannot use it.</p>
  
  <p>And when the filter is changed, Access does a requery automatically.</p>