title: Access SELECT DISTINCT doesn't work
body: <p>Ok so I have a super simple database I am using to try to implement things for a more complicated database however I keep hitting walls on what seems like simple things</p>
  
  <p>The database has one table contactsT with the fields ID first_name last_name I have one form with two combo boxes cboFirstName and cboLastName.  I have some repeat first names and I only want the combo box to show unique names.  I found this absolutely by the numbers tutorial,</p>
  
  <p><a href="https://www.techonthenet.com/access/comboboxes/unique_values2013.php" rel="nofollow noreferrer">https://www.techonthenet.com/access/comboboxes/unique_values2013.php</a></p>
  
  <p>however it doesn't work which is baffling because it seems very simple.  All that happens is I get nothing now showing in the combo box.  Don't see an option to attach the database but here is the table</p>
  
  <pre><code>ID  first_name  last_name
  1   Oliver      North
  2   Oliver      Twist
  3   Ren         Saturn
  4   John        Smith
  5   John        Ringo
  </code></pre>
  
  <p>the Row source is </p>
  
  <pre><code>SELECT DISTINCT contactsT.first_name FROM contactsT
  </code></pre>