title: Run-time error '2001' in Access SQL - suddenly occuring
body: <p>I have a continuous form in access with multiple text boxes that search a table and return the records that meet all the criteria.  It has two buttons, one that filters ("searches") and one that clears all the text boxes ("resets").  It has been working flawlessly for months.</p>
  
  <p>Today, this code started displaying, only sometimes, when I hit esc to clear the textboxes:</p>
  
  <p>" Run-time error '2001':  you canceled the previous operation."</p>
  
  <p>This is the line that the debugger highlighted:</p>
  
  <pre><code>Me.FilterOn = False
  </code></pre>
  
  <p>I am not sure why :/ here is all my code for the reset-command button:</p>
  
  <pre><code>Private Sub cmdReset_Click()
    Dim ctl As Control
    For Each ctl In Me.Section(acHeader).Controls
       Select Case ctl.ControlType
       Case acTextbox, acComboBox
           ctl.Value = Null
       Case acCheckBox
           ctl.Value = False
       End Select
    Next
    Me.FilterOn = False
  End Sub
  </code></pre>
  
  <p>But again, this all <strong><em>was</em></strong> working, and then just started freaking out.  I was editing at the time, and the code builder <em>was</em> open, but I was changing the names of labels in the form design view, not messing with the code.</p>
  
  <p>I worried that I was accidentally typing in my code builder instead of in a label, so now the code wasn't recognizing something, but I have been combing and combing and I cannot find anything out of the ordinary/doesn't match up with something.</p>
  
  <p>I have no idea what I am missing or what I did, but any help is MUCH appreciated!</p>
  
  <p>Sarah</p>