<div>
try something like<br />
<br />
dim strAgent as string<br />
strAgent=Dlookup(&quot;CurrentU<wbr />ser&quot;, &quot;LOCALtblCurrentUser&quot;)<br />
<br />
debug.print strAgent<br />
<br />
DoCmd.OpenReport &quot;rptReferrals&quot;, acViewPreview, , &quot;[Agent] =&quot;&quot; &amp;&nbsp;strAgent &amp;&nbsp;&quot;'&quot;<br />
<br />
or this <br />
<br />
DoCmd.OpenReport &quot;rptReferrals&quot;, acViewPreview, , &quot;[Agent] = '&quot; &amp;&nbsp;DLookup(&quot;[CurrentUser]&quot;, &quot;LOCALtblCurrentUser&quot;) &amp;&nbsp;&quot;'&quot; acWindowNormal
</div>


try something like

dim strAgent as string
strAgent=Dlookup("CurrentUser", "LOCALtblCurrentUser")

debug.print strAgent

DoCmd.OpenReport "rptReferrals", acViewPreview, , "[Agent] ="" & strAgent & "'"

or this

DoCmd.OpenReport "rptReferrals", acViewPreview, , "[Agent] = '" & DLookup("[CurrentUser]", "LOCALtblCurrentUser") & "'" acWindowNormal

<div>
Check the syntax of the DLookup(). &nbsp;What is the --- &amp;&nbsp;&quot;'&quot; &nbsp;--- before the ending parenthesis?
</div>


Check the syntax of the DLookup().  What is the --- & "'"  --- before the ending parenthesis?

<div>
Rey,<br />
<br />
I am trying your first suggestion but am getting &quot;Syntax error in string in query expression '[Agent] =&quot; &amp;&nbsp;strAgent &amp;&nbsp;'<br />
<br />
The degug.print returns the correct string of characters.
</div>


Rey,

I am trying your first suggestion but am getting "Syntax error in string in query expression '[Agent] =" & strAgent & '

The degug.print returns the correct string of characters.

<div>
<div class="content wysiwyg-content">
I am trying to open a report filtered by the current user. &nbsp;But I'm getting an error saying the d/b can't find the table or it is misspelled. &nbsp;It is spelled correctly. &nbsp;Do I have a syntax issue with this code...<br />
<br />
DoCmd.OpenReport &quot;rptReferrals&quot;, acViewPreview, , &quot;[Agent] = '&quot; &amp;&nbsp;DLookup(&quot;[CurrentUser]&quot;, &quot;LOCALtblCurrentUser&quot; &amp;&nbsp;&quot;'&quot;), acWindowNormal
</div>
</div>


I am trying to open a report filtered by the current user.  But I'm getting an error saying the d/b can't find the table or it is misspelled.  It is spelled correctly.  Do I have a syntax issue with this code...

DoCmd.OpenReport "rptReferrals", acViewPreview, , "[Agent] = '" & DLookup("[CurrentUser]", "LOCALtblCurrentUser" & "'"), acWindowNormal

Error can't find table ??

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.