title: Display text corresponding to Combobox selection in Microsoft Access 2010
body: <p>I have a contact form and one of the fields in a the form is a Contact_Type_ID. This field is a number field which also corresponds to a text field in another table (e.g. 1 = expatriate).</p>
  
  <p>When I cycle through the contacts, their Contact_Type_ID is 1, 2, 3... instead of Non-profit, CEO, Vice-president, etc. This is a problem because one has no idea what number 3 means.</p>
  
  <p>I would like to a combobox that only displays the corresponding text.</p>
  
  <p>I can't get the two columns and 0;1 format to work. My hunch is that it's because I'm drawing information from two different tables. I can generate the correct list, but then the main entry doesn't change as I cycle through the contacts to reflect the current contact's [Contact_Type_ID].</p>
  
  <p>I can't edit any of the current tables because I am supposed to apply this application to a much larger scale database.</p>
  
  <p>I also tried setting the SQL for the row source:</p>
  
  <pre><code>'Populate the connection combo box '
  Dim typeSQL As String
  typeSQL = "SELECT DISTINCT Contacts.[ContactTypeID], Contact_Types.[ContactType] " &amp; _
      "FROM Contacts, Contact_Types " &amp; _
      "ORDER BY Contact_Types.[ContactType];"
  Me.cbo_ContactType.RowSource = typeSQL
  </code></pre>
  
  <p>However, I then have the same problem: the combobox won't update as I cycle through the contacts. I don't understand the difference between the rowsource and the controlsource. I feel that this distinction might be key here.</p>