title: Unique Values in a Combo Box in Access
body: <p>Ok, here is my dilemma. (Using Access 2010)</p>
  
  <p>I have created a access db, to manage the computer hardware inventory at my job.
  I created a Form with a unbound combo box allowing only unique values. Also on the form I added a report, that will match all applicable equipment to a username. The goal is when I click "John Smith" it will show all the items "John Smith" has (I have gotten this to work).</p>
  
  <p>This Combo Box does pull its data from a Table, where there are multiples of the same name in different rows.</p>
  
  <p>Here is the SQL Code for the Combo Box</p>
  
  <pre><code>SELECT DISTINCT [Master Inventory].ID, [Master Inventory].User
  FROM [Master Inventory]
  ORDER BY [Master Inventory].User;
  </code></pre>
  
  <p>The issue is that my Combo Box Still shows multiples of same names even though I have told to use Unique Values. Any help would be appreciated. </p>