title: add rowsource to multicolumn Listbox in access 2013
body: <p>I have a form in Microsoft Acsess 2013 showing filtered records after selection by user.</p>
  
  <p>I added a Listbox showing <strong>different type</strong> of ITEM. I managed to get the result by writing:</p>
  
  <pre class="lang-sql prettyprint-override"><code>Listbox.RowSource = "SELECT DISTINCT ITEM FROM TABLE WHERE " &amp; strUserInput
  </code></pre>
  
  <p>which strUserInput is the filter condition.</p>
  
  <p>I searched up and down, tried Listbox.AddItem, set properties of Listbox (Row Source Type) to Value List, etc. But none of them is working. Can anybody show me how to <strong>sum up</strong> the quantity of each ITEM and <strong>show</strong> it at the second column of the Listbox? Your help is much appreciated!</p>