title: docmd.applyfilter on navigation form in MS Access
body: <p>Is there anyway to apply a filter (without using SQL script), when using a navigation form?</p>
  
  <p>When I do the docmd.applyfilter outside of the navigation form it works.
  When I move the form to my navigation form it no longer works - I have looked at how I reference my form etc. </p>
  
  <p>Code I have is </p>
  
  <pre><code>Dim BusinessTermLookup As String
  
  BusinessTermLookup = Me!CmbSimilarMatch
  Me.Filter = "[businessterm]like ' &amp; BusinessTermlookup '"
  Me.FilterOn = True
  </code></pre>
  
  <p>I tried to use docmd.applyfilter - but it gives an error </p>
  
  <blockquote>
    <p>The action or method is invalid because the form or report isn't bound to a table or query</p>
  </blockquote>