title: Use List Box with Multiple Selection in Query
body: <p>Given I've created an Access Form with a ListBox; <code>property &gt; other &gt; Multi Select = Extended</code>; which permits multiple selections.</p>
  
  <p>User selects multiple items.</p>
  
  <p>Clicks a button that creates a report in "Print Preview"; but this report is based on the query, and the query is based on the values in the form.</p>
  
  <p>This is accomplished by using this in the query when viewing in Access Query Design View (not SQL): </p>
  
  <pre><code>Like ([forms]![padc]![V2])
  </code></pre>
  
  <p>Where the form name is <code>padc</code> and the value to compare is <code>V2</code>.</p>
  
  <p>Previously, rather than the ListBox that might show 10 options, <code>V2</code> was just a field with one value. A user would either type a partial value, such as <code>jack*</code>, and the report would pull every instance where this value began with <code>jack</code>; whether that was <code>jack</code>, or <code>jackie</code>, or <code>jacko</code>, or <code>jackson</code>, etc. The <code>LIKE</code> part of this permitted the "fuzzy" logic bringing about varied results. The query would run, and the report would show all the records with anything starting with <code>jack</code>.  </p>
  
  <p>My goal, really, is to have a user select one, two or three, or all the available options in this box, and have the report respond correctly.</p>
  
  <p>I believe the ListBox will let me do this, provided I have all the right names in the table that is the source of the options available to choose from. </p>
  
  <p>I set the listbox to "multi-select" to enable multiple selections on the form.
  The form is happy. It can let me click/highlight one or several items from the list.</p>
  
  <p>The query is not happy. </p>
  
  <p>For the field V2, neither </p>
  
  <pre><code>Like ([forms]![padc]![V2])
  </code></pre>
  
  <p>nor </p>
  
  <pre><code>=([forms]![padc]![V2])
  </code></pre>
  
  <p>Will retrieve records to populate the report; regardless of whether or not just one value in ListBox is selected or multiple values. (<code>Like</code> = fuzzy, and <code>=</code> means exact match.)</p>
  
  <p>Neither work.</p>
  
  <p>Of course, if the query won't perform, then the report won't perform either.  </p>
  
  <p>How can I write the correct query in Access, using "Query View = Design View" and or SQL to get this to function properly?</p>
  
  <p>If the answer is "it can't be done without using VBA" then please point me to the VBA solution that a 5-yr old can understand, because I have zero experience using VBA.  </p>
  
  <p>Folks have recommended I use VBA; specifically that I should incorporate the "<code>IN()</code>   IN function" in some manner; but I don't comprehend this solution at all.  </p>
  
  <p>I admit to being ignorant; not stupid; but ignorant. </p>