title: How to add an <ALL> option to an access ComboBox
body: <p>Okay, so after spending a few hours on this, and following numerous online tutorials, I still cant get this ..working.. </p>
  
  <p>Basically,I have the ComboBox displaying an <code>&lt;ALL&gt;</code> option, but for the report, it doesn't actually return anything, it's just simply there for aesthetics at the moment. How do I get it to return data? There are 3 combo box's that need to be filled out, one being Treatment Type, another for Treatment Date (Both of which will frequently use (ALL) ), and Birth Month, which will always be a specific month.</p>
  
  <p>The query for the Treatment Type ComboBox is as follows:</p>
  
  <pre><code>Select "(All Records)" 
  FROM Treatment
  UNION Select Treatment.Treatment
  From Treatment;
  </code></pre>
  
  <p>The query for the Treatment Date ComboBox is as follows:</p>
  
  <pre><code>Select 0, "(All Records)"  
  FROM Events 
  UNION 
  Select  Events.DatefieldID, Events.Datefields
  From Events;
  </code></pre>