<div>
&lt;&lt;<br />
=DLookUp(&quot;[Gen-FirstName]&quot;<wbr />,&quot;[Main]&quot;,<wbr />&quot;[Employee<wbr />ID]= &quot;&nbsp;&amp; [EmployeeID]) <br />
<br />
&gt;&gt;<br />
<br />
Also, make sure you are using the name of the table and field you're looking this up in (not the name of the form and textbox)<br />
<br />
&gt;&gt;&nbsp;I'm using (Table = &quot;HR Log&quot;)<br />
<br />
If your table's name is HR Log, you would use that in the DLookup:<br />
<br />
<br />

<pre><code id="code-20-38782286-1">=DLookUp(&quot;[Gen-FirstName]&quot;,&quot;[HR Log]&quot;,&quot;[EmployeeID]= &quot; &amp; [EmployeeID]) </code></pre>
<br />
Jim Dettman's article explains this stuff very thoroughly:<br />
<a href="https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html" rel="ugc">https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html</a>
</div>


<<
=DLookUp("[Gen-FirstName]","[Main]","[EmployeeID]= " & [EmployeeID])

>>

Also, make sure you are using the name of the table and field you're looking this up in (not the name of the form and textbox)

>> I'm using (Table = "HR Log")

If your table's name is HR Log, you would use that in the DLookup:




=DLookUp("[Gen-FirstName]","[HR Log]","[EmployeeID]= " & [EmployeeID]) 


Jim Dettman's article explains this stuff very thoroughly:
https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html [https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_12-Dlookup-and-the-Domain-Functions.html]

<div>
perfect - thank you for the swift response
</div>


perfect - thank you for the swift response

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
For the life of me I can't get this dlookup to work<br />
<br />
=DLookUp(&quot;[Gen-FirstName]&quot;<wbr />,&quot;[Main]&quot;,<wbr />&quot;[Employee<wbr />ID]= '&quot; &amp;&nbsp;[EmployeeID] &amp;&nbsp;&quot;'&quot;)<br />
<br />
I've tried various different methods, but all fail<br />
<br />
=DLookUp(&quot;[Gen-FirstName]&quot;<wbr />,&quot;Main&quot;,&quot;[<wbr />EmployeeID<wbr />]= '&quot; &amp;&nbsp;[Me].[EmployeeID] &amp;&nbsp;&quot;'&quot;)<br />
<br />
Gen-FirstName is the field I want returned from the table &quot;Main&quot;<br />
<br />
The link is EmployeeID (Autonumber in Main) &amp;&nbsp;a long interger number in the table behind the form I'm using (Table = &quot;HR Log&quot;)<br />
<br />
Can anybody help
</div>
</div>


Dear Experts,

For the life of me I can't get this dlookup to work

=DLookUp("[Gen-FirstName]","[Main]","[EmployeeID]= '" & [EmployeeID] & "'")

I've tried various different methods, but all fail

=DLookUp("[Gen-FirstName]","Main","[EmployeeID]= '" & [Me].[EmployeeID] & "'")

Gen-FirstName is the field I want returned from the table "Main"

The link is EmployeeID (Autonumber in Main) & a long interger number in the table behind the form I'm using (Table = "HR Log")

Can anybody help

dlookup help Access

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.