title: Populating a form with a dropdown - Access
body: <p>I am trying to create a form in access that has a dropdown at the top and will populate the rest of the form with the record that corresponds to what is chosen.</p>
  
  <p>I have looked at 2 different guides online but both point to older versions of Access and I think I am missing something.</p>
  
  <p>So. The order that I did everything:</p>
  
  <ol>
  <li><p>I went to the table for the form. And I clicked Form. This made a quick form with all of the fields as text boxes.</p></li>
  <li><p>I deleted the field that will be the dropdown and I put in a dropdown canceling the wizard</p></li>
  <li><p>In the data section for the dropdown. I edited "Row Source" to select the field that will be in the dropdown and the unique ID, in that order.</p></li>
  <li><p>I set the bound Column to 2 (I have tried both)</p></li>
  <li><p>I set the name of the Combo Box to "TitleSelector"</p></li>
  <li><p>In Form Settings. For "Record Source". I have "[forms]![Edit Piece].[TitleSelector] &amp; "*" in Criteria for "ID". I also have the rest of the fields in the Query listed</p></li>
  <li><p>I added the "me.requery" to on change
  Not sure if it means anything. When I was typing in the Criteria for "ID" it did not show "TitleSelector" in the drop down. </p></li>
  </ol>
  
  <p>I am using Access 2010</p>
  
  <p>Edit:
  My Problem -
  The dropdown itself shows everything correctly. However nothing happens when I choose something</p>
  
  <p>Edit:</p>
  
  <pre><code>SELECT Pieces.ID, Pieces.Title, Pieces.Composer, Pieces.Instrumentation, Pieces.Location, Pieces.Location_2
  FROM Pieces
  WHERE (((Pieces.ID)=[forms]![Edit Piece].[TitleSelector]));
  </code></pre>
  
  <p>Edit:
  Here is a link to a copy of my database: <a href="https://www.dropbox.com/s/tpnqm686tj653fg/Trisha%20Database.accdb" rel="nofollow">https://www.dropbox.com/s/tpnqm686tj653fg/Trisha%20Database.accdb</a></p>