<div>
One way you can handle this is:<br />
<br />
Me.txtEquipment = DLookup(&quot;[Equip Name]&quot;, &quot;Equipment&quot;, &quot;[Equip Name] = &quot;&nbsp;&amp; &nbsp;chr$(34) &amp;&nbsp; Forms!frmScheduleWorkOrder<wbr />!subfrmSch<wbr />eduleEquip<wbr />ment.Form!<wbr />txtEquipNa<wbr />me &amp;&nbsp;chr$(34))<br />
<br />
Jim.
</div>


One way you can handle this is:

Me.txtEquipment = DLookup("[Equip Name]", "Equipment", "[Equip Name] = " &  chr$(34) &  Forms!frmScheduleWorkOrder!subfrmScheduleEquipment.Form!txtEquipName & chr$(34))

Jim.

SteveL13

<div>
Jim, your solution worked but I just discovered I get the syntax error message when EquipName has &quot;&nbsp;marks in it.
</div>


Jim, your solution worked but I just discovered I get the syntax error message when EquipName has " marks in it.

<div>
Daniel, I can't get your solution to work at all. I'm sure I'm doing something wrong.
</div>


Daniel, I can't get your solution to work at all. I'm sure I'm doing something wrong.

<div>
You'll need to use Daniel's approach then of doubling up on the delimiter.<br />
<br />
his code should go in &nbsp;a standard module.<br />
<br />
Jim.
</div>


You'll need to use Daniel's approach then of doubling up on the delimiter.

his code should go in  a standard module.

Jim.

<div>
<div class="content wysiwyg-content">
I'm getting a syntax error on this line of code when the text of EquipName has an apostrophe in it like &quot;16' BLACK UTILITY&quot;<br />
<br />
Me.txtEquipment = DLookup(&quot;[Equip Name]&quot;, &quot;Equipment&quot;, &quot;[Equip Name] = '&quot; &amp;&nbsp;Forms!frmScheduleWorkOrder<wbr />!subfrmSch<wbr />eduleEquip<wbr />ment.Form!<wbr />txtEquipNa<wbr />me &amp;&nbsp;&quot;'&quot;)
</div>
</div>


I'm getting a syntax error on this line of code when the text of EquipName has an apostrophe in it like "16' BLACK UTILITY"

Me.txtEquipment = DLookup("[Equip Name]", "Equipment", "[Equip Name] = '" & Forms!frmScheduleWorkOrder!subfrmScheduleEquipment.Form!txtEquipName & "'")

Syntax error on this line of code when the text of EquipName has an apostrophe in it

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.