<div>
Try :<br />
<br />
=DLookUp(&quot;[Optic Description]&quot;;&quot;[Optics]&quot;;&quot;<wbr />[Optics] = &quot;&nbsp;&amp; Form![Top Optics])
</div>


Try :

=DLookUp("[Optic Description]";"[Optics]";"[Optics] = " & Form![Top Optics])

<div>
Try this:<br />
<br />
=DLookUp(&quot;[Optic Description]&quot;,&quot;[Optics]&quot;,&quot;<wbr />[OpticID] = &quot;&nbsp;&amp; Me.[Top Optics])
</div>


Try this:

=DLookUp("[Optic Description]","[Optics]","[OpticID] = " & Me.[Top Optics])

<div>
Sorry, mistake, here's to good one :<br />
<br />
=DLookUp(&quot;[Optic Description]&quot;;&quot;[Optics]&quot;;&quot;<wbr />[OpticID] = &quot;&nbsp;&amp; Form![Top Optics])
</div>


Sorry, mistake, here's to good one :

=DLookUp("[Optic Description]";"[Optics]";"[OpticID] = " & Form![Top Optics])

<div>
we have fast typers here :)<br />
BTW: the semi-colon is valid in a french setup, for example (see the Windows &quot;list separator&quot;), and the &quot;Me.&quot; syntax does not work in a control source...<br />
Cheers!
</div>


we have fast typers here :)
BTW: the semi-colon is valid in a french setup, for example (see the Windows "list separator"), and the "Me." syntax does not work in a control source...
Cheers!

<div>
<div class="content wysiwyg-content">
This is what I have in the Control Source<br />
<br />
=DLookUp([Optic Description],[Optics],[Opt<wbr />ics]!Optic<wbr />ID=[Top Optics])<br />
<br />
but it gives me: #Name?<br />
<br />
<br />
I am trying to look up a description from the Optics table where The OptiicID is the same as the current displayed record on the form.<br />
<br />
Thanks!
</div>
</div>


This is what I have in the Control Source

=DLookUp([Optic Description],[Optics],[Optics]!OpticID=[Top Optics])

but it gives me: #Name?


I am trying to look up a description from the Optics table where The OptiicID is the same as the current displayed record on the form.

Thanks!

DLookup in the Control Source Property of a Form Text Box

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.