title: Remove duplicate in combobox in Data Entry Form (Microsoft Access 2010)
body: <p>I am developing a simple database for a competition by Microsoft Access 2010. There are one issue that I am facing right now and I need your help.</p>
  
  <p>In my table Schools, I have a list of school that participate in the competition, with the year they participate (the competition is organized every year and 1 school can participate in many years). I also have another table called Team, which contain teams that come from different schools, and I create a Data Entry Form for this entity. And to make it easy to type in, I create a combobox for school list, so that when people type in team information, they can easily choose their school name from the list.</p>
  
  <p>However, because 1 school can participate in many years, then there are duplicates in my combobox. Could you please help me how to remove the duplicates? </p>
  
  <p>I tried SELECT DISTINCT but it did not work. </p>
  
  <p>Any recommend? Thks in advance.</p>