title: Filter form with combobox using macro - MS Access
body: <p>I have created a multiple items form in MS Access 2013 that takes data from a query. I have created filters using macros but the problem is that they only work if in the combobox the rowsource is just text and not the content of a table. In my case that's not practical cause I have dozens of entries and I can't just use text values in it.</p>
  
  <p>So far I have this in the macro to create filter:</p>
  
  <pre><code>"=[project number]='" &amp; [Forms]![MyForm]![comboboxProject] &amp; "'" 
  </code></pre>
  
  <p>but it doesn't work. I don't know if it's because I have a multiple items form, instead of a simple one. By the way project number is a column of my data and is just text.</p>
  
  <p>After hours of debugging I found that my combobox has two columns, a hidden one with the id of the project and a visible one with the project number. I tried using [comboboxProject].Column(1) but it says that function Column is not defined. So I need to find a way to get only one column as text from my combobox and the problem would be solved.</p>
  
  <p>Thank you very much in advance for your help!</p>