<div>
Try this:<br />
<br />
DLookup(&quot;UserType&quot;, &quot;tblUsers&quot;, &quot;Password = '&quot; &amp;&nbsp;Me.Password &amp;&nbsp;&quot;'&quot;)<br />
<br />
Ed<br />

</div>


Try this:

DLookup("UserType", "tblUsers", "Password = '" & Me.Password & "'")

Ed


<div>
<div class="content wysiwyg-content">
This is so frustrating. I have asked a similar question over the years no less than 10 times. All of the answers are in my knowledge base and I still can't figure it out.<br />
<br />
I am getting a #NAME? error for this:<br />
<br />
DLookup(&quot;UserType&quot;, &quot;tblUsers&quot;, &quot;Password = &quot;&nbsp;&amp; Chr(34) &amp;&nbsp;Me.Password &amp;&nbsp;Chr(34) &amp;&nbsp;&quot; &quot;)<br />
<br />
Me.Password is text.
</div>
</div>


This is so frustrating. I have asked a similar question over the years no less than 10 times. All of the answers are in my knowledge base and I still can't figure it out.

I am getting a #NAME? error for this:

DLookup("UserType", "tblUsers", "Password = " & Chr(34) & Me.Password & Chr(34) & " ")

Me.Password is text.

Syntax help needed for DLookup

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.