title: Microsoft Access - Combo Box - cannot add record, join key of table is not in recordset
body: <p>No matter how many tutorial, guides, or example I try to learn from; I can't seem to figure out how to make mine work. Its almost like a hit and miss when it comes to it. I got it working on some forms but I can't seem to get it working on others. Is there a trick to getting a combo box working; That I am missing?!</p>
  
  <p>for example in my vendor form.</p>
  
  <p>frm_vendor</p>
  
  <pre><code>   tbl_vendor  -&gt;      tbl_address    -&gt;     tbl_addressType
  PK vendorID         PK addressID          PK addressTypeID  
  FK addressID        FK addressTypeID
  </code></pre>
  
  <p>I am able to create a combo box which allows you to select the addressTypeID &lt;- no problem</p>
  
  <p><code>control source = addressTypeID</code></p>
  
  <p><code>row source =SELECT [tbl_addressType].[addressTypeID], [tbl_addressType].[addressType] FROM tbl_addressType;</code></p>
  
  <p><code>row source type = Query/Table</code></p>
  
  <p><code>bound to column = 1</code></p>
  
  <p><code>limit to list = 1</code></p>
  
  <p><code>not editable</code></p>
  
  <p>But on this new form, I can't see to get it working.</p>
  
  <p><code>control source = addressTypeID</code> seems to be invalid and gives me a warning.</p>
  
  <p>When you create a form base off a query. Should I be including every PK / FK in this query even thought I wont be displaying it, so the form can understand the links? </p>