title: Is there a way to filter a report based on a textbox that will exclude whatever is in the textbox?
body: <p>I want to filter a report by excluding any word in a textbox. I can do this in a frame but I can't seem to do it by itself in a textbox. The reason I am doing this, is because I would ideally like to have 3 frames with option buttons that will allow me to filter the report based on what is in the textboxes.</p>
  
  <p>For example the three option buttons are associated with a textbox that will filter office titles. The three option buttons are begins with, contains and exclude. This works fine but the issue is I cannot combine multiple frames. I would want to filter something like 'begins with director but excludes senior'.</p>
  
  <pre><code>If Nz(Me.txtOffice, "") &lt;&gt; "" Then
     If Me.Frame19 = 1 Then
         stroffice = stroffice &amp; "OFFICETITLE Like '" &amp; Me.txtOffice &amp; "*' AND "
         End If
      If Me.Frame19 = 2 = True Then
         stroffice = stroffice &amp; "OFFICETITLE Like '*" &amp; Me.txtOffice &amp; "*' AND "
         End If
      If Me.Frame19 = 3 = True Then
         stroffice = stroffice &amp; "OFFICETITLE Not Like '*" &amp; Me.txtOffice &amp; "*' AND "
         End If
  </code></pre>
  
  <p>Is there a way to have multiple frames filter a report or is there a way to have a textbox filter by excluding the word in the textbox?</p>