title: How to clear filtering on selection of a value from the combobox in ms access 2007?
body: <p>I have a combobox that filters data on the form in the afterupdate event.
  Following is the query I have been trying to use to filter data.This code filters data effectively but the problem that I am facing is that when I select "" from the combobox no data is displayed.What could be wrong?How can I display all the data of the form on selection of ""</p>
  
  <pre><code>Dim strCriteria As String
  strCriteria = "[Jobno]='" &amp; cboPMNO &amp; "'"
  Set rst = Me.RecordsetClone
  If strCriteria = "&lt;ALL&gt;" Then
  Me.FilterOn = False
  ElseIf rst.NoMatch Then
  MsgBox "No entry found"
  Else
  Me.FilterOn = False
  Me.Filter = strCriteria
  Me.FilterOn = True
  End If
  </code></pre>