title: In MS-Access, how to display the old foreign key in a combo box when the foreign key no longer exists?
body: <p>I have a combobox with two columns.  The first column is hidden.  The second is not hidden.  The first column is the bound column.  The second is the display text. </p>
  
  <pre><code>ColumnCount = 1
  ColumnWidths = 0";1"
  RowSource = "a select statement"
  BoundColumn = 1
  </code></pre>
  
  <p>For example:</p>
  
  <pre><code>SKU       | Description
  "teapot"  | "Pretty Teapots"
  "saucer"  | "Excellent Saucers"
  "tallcup" | "Tall Cups"
  </code></pre>
  
  <p>The user sees the second column in the combo box. Everything works. If the user chooses "Tall Cups", then "tallcup" is stored in the underlying table.</p>
  
  <p>Later....
  The value "tallcup" is removed from the list on purpose.  What I now want is for the user to see "tallcup" in the Combo Box for those records where it was originally set.  But for new records, "tallcup" is not an option.  </p>
  
  <p>What it currently shows is blank.  It's as if nothing was ever selected.</p>
  
  <p>Do I need to do something with the <code>format</code> property?</p>
  
  <p>Here are some related links that I found around the internet, but they didn't help me much:</p>
  
  <p><a href="http://www.tutcity.com/access/display-the-corresponding-unbound-column-entry-of-a-combobox.79599.html" rel="nofollow">http://www.tutcity.com/access/display-the-corresponding-unbound-column-entry-of-a-combobox.79599.html</a></p>
  
  <p><a href="https://www.google.com/search?q=ms-access+2+column+show+first+combobox+missing+show+anyway&amp;rls=com.microsoft%3Aen-us%3AIE-SearchBox&amp;oe=&amp;gws_rd=ssl&amp;oq=&amp;gs_l=" rel="nofollow">https://www.google.com/search?q=ms-access+2+column+show+first+combobox+missing+show+anyway&amp;rls=com.microsoft%3Aen-us%3AIE-SearchBox&amp;oe=&amp;gws_rd=ssl&amp;oq=&amp;gs_l=</a></p>
  
  <p><a href="http://www.experts-exchange.com/Database/MS_Access/A_5890-Adding-the-option-all-to-a-ComboBox.html" rel="nofollow">http://www.experts-exchange.com/Database/MS_Access/A_5890-Adding-the-option-all-to-a-ComboBox.html</a></p>