title: MS Access - go to another subform using the same record id
body: <p>I have a main form with a tab control, and each tab has a different subform.  Two of the subforms have the same underlying query (a list of projects).  I have a button that I want to take the user from the first tab to the second tab, but I want the record on the second tab to be the same as it was on the first tab.</p>
  
  <p>For example, if this is the structure (but between frmMaster and the subforms is a tab control, but I don't think that impacts what I'm trying to do):</p>
  
  <pre><code>frmMaster
  - frm_Sub1 (on the first tab)
  - frm_Sub2 (on the second tab)
  </code></pre>
  
  <p>And a user navigates a certain project on frm_Sub1, I want them to be able to hit a button, and they will be taken to that same project record on frm_Sub2.  I can set focus on the second tab (using Forms!frmMaster.form!TabCtl0.Pages(1).SetFocus), but I can't get the subform on that tab to jump to the correct record.  I think it's just an issue with how I'm trying to reference the subform--any suggestions?  Thanks.</p>