<div>
Try this:<br />
<br />
strFilter = &quot;[Description] = &quot;&nbsp;&amp; Chr(34) &nbsp;&amp; strSearch &amp;&nbsp;Chr(34)<br />
Me.Filter = strFilter<br />
Me.FilterOn = True<br />
<br />
mx
</div>


Try this:

strFilter = "[Description] = " & Chr(34)  & strSearch & Chr(34)
Me.Filter = strFilter
Me.FilterOn = True

mx

<div>
<div class="content wysiwyg-content">
What am I doing wrong with the strFilter portion of this code. &nbsp;I get the attached error everytime.<br />
I am trying to filter the records to only get records with LIKE results in the column called Description. &nbsp;In the test I was looking for the word GOD.<br />
<br />
strFilter = &quot;Description LIKE '&quot; &amp;&nbsp;strSearch '&quot;<br />
Me.Filter = strFilter<br />
Me.FilterOn = True<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/04_w18/447508/code.jpg" target="_blank" title="Error message (25 KB)"><img alt="Error message" class="file-block lazyload" style="max-width: 381px;" data-src="https://filedb.experts-exchange.com/incoming/2011/04_w18/447508/code.jpg" /></a> <a href="https://filedb.experts-exchange.com/incoming/2011/04_w18/447508/code.jpg" target="_blank" title="Error message (25 KB)"><img alt="Error message" class="file-block lazyload" style="max-width: 381px;" data-src="https://filedb.experts-exchange.com/incoming/2011/04_w18/447508/code.jpg" /></a>
</div>
</div>


code.jpg

What am I doing wrong with the strFilter portion of this code.  I get the attached error everytime.
I am trying to filter the records to only get records with LIKE results in the column called Description.  In the test I was looking for the word GOD.

strFilter = "Description LIKE '" & strSearch '"
Me.Filter = strFilter
Me.FilterOn = True
  

Me.Filter Query question

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.