title: VBA ms access remove form filter
body: <p>I have a form that is filtered using the value chosen in a combox and then pressing a button. It works well.
  Then I have another button to remove the filter and the form shows all the values. The latter does not work well, although I have found a slightly odd solution.</p>
  
  <p>If in the on click event of the remove filters button I put:</p>
  
  <pre><code>Me.Form.Filter = ""
  Me.Form.FilterOn = False
  Me.combox22 = Null
  </code></pre>
  
  <p>IT DOES NOT WORK</p>
  
  <p>if in the on click event of the remove filters button I put:</p>
  
  <pre><code>
      Me.Form.Filter = ""
  Me.Form.FilterOn = False
  Me.combox22 = Null
  Me.Form.Filter = ""
  Me.Form.FilterOn = False
  Me.combox22 = Null
  </code></pre>
  
  <p>IT WORKS PERFECTLY</p>
  
  <p>Why I have to duplicate the code?</p>