<div>
<br />
<br />
Try this:<br />
<br />
If DLookup(&quot;[Product Desc]&quot;, &quot;Product Table&quot;, &quot;Replace([Product Desc],Chr(34),&quot;&quot;) = &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;Replace(Me![ProductDesc],C<wbr />hr(34),&quot;&quot;)<wbr /> &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; And [Vendor #] = &quot;&nbsp;&amp; Me![cmbVendor]) &lt;&gt;&nbsp;&quot;&quot; Then<br />
<br />
mx
</div>




Try this:

If DLookup("[Product Desc]", "Product Table", "Replace([Product Desc],Chr(34),"") = " & Chr(34) & Replace(Me![ProductDesc],Chr(34),"") & Chr(34) & " And [Vendor #] = " & Me![cmbVendor]) <> "" Then

mx

<div>
Perfect! &nbsp;Thank you ~ Jacob
</div>


<div>
<div class="content wysiwyg-content">
If DLookup(&quot;[Product Desc]&quot;, &quot;Product Table&quot;, &quot;[Product Desc] = &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;Me![ProductDesc] &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; And [Vendor #] = &quot;&nbsp;&amp; Me![cmbVendor]) &lt;&gt;&nbsp;&quot;&quot; Then<br />
<br />
When the field value of Me![ProductDesc] contains a single set of double quotes (&quot;), i.e. [1/2&quot; pipe cap], the lookup fails.<br />
<br />
Can you suggest a remedy?<br />
<br />
Many Thanks, Jacob<br />

</div>
</div>


If DLookup("[Product Desc]", "Product Table", "[Product Desc] = " & Chr(34) & Me![ProductDesc] & Chr(34) & " And [Vendor #] = " & Me![cmbVendor]) <> "" Then

When the field value of Me![ProductDesc] contains a single set of double quotes ("), i.e. [1/2" pipe cap], the lookup fails.

Can you suggest a remedy?

Many Thanks, Jacob


Single Set of Double Quotes (&quot;) in field value in DLookup Statement = Error 3075

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.

Single Set of Double Quotes (&quot;) in field value in DLookup Statement = Error 3075

Single Set of Double Quotes (") in field value in DLookup Statement = Error 3075