title: Using values from multi-select list box in MS Access Query
body: <p>I have one table in my MS Access data base named COA_Map. I also have a form with a multi-select list box. When the values are selected, vba turns them into a string and updates a text box with the string. I want to use the textbox string as a variable in a query.</p>
  
  <p><a href="https://i.stack.imgur.com/Nf7p6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Nf7p6.png" alt="enter image description here"></a></p>
  
  <p>This is my query:<code>SELECT * FROM COA_Map WHERE (COA_Map.ASL IN ( [Forms]![Multi-Select Search]![TextASL].Text  ) );
  </code>
  This returns empty results. When I copy and  paste the text box values into the query like this:</p>
  
  <pre><code>SELECT * FROM COA_Map WHERE (COA_Map.ASL IN ( 2.1,2.3,2.4  ) );
  </code></pre>
  
  <p>I get the expected results. I tried <code>[Forms]![Multi-Select Search]![TextASL].Value</code> and <code>[Forms]![Multi-Select Search]![TextASL]</code> but that gives an error "This expression is typed incorrectly, or it is too complex" </p>
  
  <p>I also tried using "OR" clause instead of "IN". I changed the VBA to return this string: 
  <a href="https://i.stack.imgur.com/29aOe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/29aOe.png" alt="enter image description here"></a></p>
  
  <p>to build this query: <code>SELECT * FROM COA_Map WHERE COA_Map.ASL = [Forms]![Multi-Select Search]![TextASL] ;</code> </p>
  
  <p>This returns the same empty results. When I paste the textbox values into the query like this: <code>SELECT * FROM COA_Map WHERE COA_Map.ASL = 2.1 OR COA_Map.ASL = 2.2 OR COA_Map.ASL = 2.3 ;
  </code> , I get expected results.</p>
  
  <p>When only one value is selected in either version of the query, I get expected results.</p>
  
  <p>I can't figure out why the the query will not return results when reading from the text box with multiple values selected. </p>