<div>
I will try your suggestions and get back with you this evening ... thank you!
</div>


<div>
<div class="content wysiwyg-content">
I am getting a syntax error on this, and similar versions, please advise. &nbsp;Thank you.<br />
<br />
dim strVal as string<br />
strVal = &quot;Joe Smith&quot;<br />
docmd.applyfilter(&quot;filterN<wbr />ame&quot;), &quot;fieldName1=&quot; &amp;&nbsp;strVal
</div>
</div>


I am getting a syntax error on this, and similar versions, please advise.  Thank you.

dim strVal as string
strVal = "Joe Smith"
docmd.applyfilter("filterName"), "fieldName1=" & strVal

I will try your suggestions and get back with you this evening ... thank you!

Applyfilter using string variable

I am getting a syntax error on this, and similar versions, please advise.  Thank you.

dim strVal as string
strVal = &amp;quot;Joe Smith&amp;quot;
docmd.applyfilter(&amp;quot;filterName&amp;quot;), &amp;quot;fieldName1=&amp;quot; &amp;amp; strVal

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.