title: Search and filter in MS Access forms
body: <p>Background: I have a table named 'SNR_log', out of which I have queried to obtain below list.<img src="https://i.stack.imgur.com/niH9C.jpg" alt="table SNR_Log"></p>
  
  <p>Next,I designed a split form, with a text box.In this text box SNR is enterted to find and filter from the list. To perform this operation 'Apply filter' macro is used with a where condition,</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="false" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>[SNR] Like "*" &amp; [Forms]![SNR_History]![Text17] &amp; "*"</code></pre>
  </div>
  </div>
  </p>
  
  <p>Problem: Is it possible to filter by inserting SNR in the textbox and obtaining the below result.
  <img src="https://i.stack.imgur.com/8P4DT.jpg" alt="here UID is filtered"></p>
  
  <p>In other words, with SNR as input, display UID and all the SNR under that UID.</p>