<div>
To dreamtime now ~~<br />
WCB l-a-t-e-r ~~<br />
Many thanks, Jacob
</div>


To dreamtime now ~~
WCB l-a-t-e-r ~~
Many thanks, Jacob

<div>
<div class="content wysiwyg-content">
Hello ~<br />
<br />
Following DLookup works superbly! when &quot;ttSitus&quot; is TEXT string (Thank You Gustav!):<br />
Me.ttSitus = DLookup(&quot;[ttSitus]&quot;, &quot;tblTimeTracking&quot;, &quot;[ttPerson] = '&quot; &amp;&nbsp;Forms!frmTimeTracking!ttPe<wbr />rson &amp;&nbsp;&quot;' And [ttID] = &quot;&nbsp;&amp; DMax(&quot;[ttID]&quot;, &quot;tblTimeTracking&quot;, &quot;[ttPerson] = '&quot; &amp;&nbsp;Forms!frmTimeTracking!ttPe<wbr />rson &amp;&nbsp;&quot;'&quot;) &amp;&nbsp;&quot;&quot;)<br />
<br />
Changing this to work w/ a DATE &quot;ttDates&quot;, field = no errors, but returns only NULL value... &nbsp;Could anyone suggest a revision?:<br />
Me.ttDates = DLookup(&quot;# &amp;&nbsp;[ttDates] &amp;&nbsp;#&quot;, &quot;tblTimeTracking&quot;, &quot;[ttPerson] = '&quot; &amp;&nbsp;Forms!frmTimeTracking!ttPe<wbr />rson &amp;&nbsp;&quot;' And [ttID] = &quot;&nbsp;&amp; DMax(&quot;[ttID]&quot;, &quot;tblTimeTracking&quot;, &quot;[ttPerson] = '&quot; &amp;&nbsp;Forms!frmTimeTracking!ttPe<wbr />rson &amp;&nbsp;&quot;'&quot;) &amp;&nbsp;&quot;&quot;)
</div>
</div>


Hello ~

Following DLookup works superbly! when "ttSitus" is TEXT string (Thank You Gustav!):
Me.ttSitus = DLookup("[ttSitus]", "tblTimeTracking", "[ttPerson] = '" & Forms!frmTimeTracking!ttPerson & "' And [ttID] = " & DMax("[ttID]", "tblTimeTracking", "[ttPerson] = '" & Forms!frmTimeTracking!ttPerson & "'") & "")

Changing this to work w/ a DATE "ttDates", field = no errors, but returns only NULL value...  Could anyone suggest a revision?:
Me.ttDates = DLookup("# & [ttDates] & #", "tblTimeTracking", "[ttPerson] = '" & Forms!frmTimeTracking!ttPerson & "' And [ttID] = " & DMax("[ttID]", "tblTimeTracking", "[ttPerson] = '" & Forms!frmTimeTracking!ttPerson & "'") & "")

DLookup Syntax: DATE; Multiple criteria

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.