title: Form Filter by Month
body: <p>I have a Problem with my filter for a form. The form contains activity of persons on specific dates during a month.</p>
  
  <p>I have a combobox:<br>
  <img src="https://i.stack.imgur.com/KIaCh.png" alt="combobox">. </p>
  
  <p>This combobox RowSource groups and formats dates into month name and year (mmmm jj):<br>
  <img src="https://i.stack.imgur.com/ftYf3.png" alt="query"></p>
  
  <p>The combobox is unbound and has this OnClick event:</p>
  
  <pre><code>    Private Sub Kombinationsfeld479_Click()
      Me.Filter = "[tbl_Taetigkeitserfassung.TaetigkeitsDatum] = " 
      &amp; Format(Nz(Me!Kombinationsfeld479, Date), "\#yyyy-mm\#")
      Me.FilterOn = True
  </code></pre>
  
  <p>Filter of the form, when selecting October 18:</p>
  
  <pre><code>[tbl_Taetigkeitserfassung.TaetigkeitsDatum] = #2018-10#
  </code></pre>
  
  <p>But in the End it just shows the 01.01.2018.<br>
  I know there is a format mistake somewhere.</p>
  
  <p>Thanks for your help!</p>
  
  <p>P.S.: Is there a possibility to add a  "Show All" selection within the combobox?</p>