<div>
Sorry, I missed both vars are string. &nbsp;It should look like this:<br />
<br />
DLookup(&quot;Signature&quot;, &quot;Employees&quot;, &quot;ProviderNumber = '&quot; &amp;&nbsp;provnum &amp;&nbsp;&quot;' and Password = '&quot; &amp;&nbsp;pass &amp;&quot;'&quot;) <br />

</div>


Sorry, I missed both vars are string.  It should look like this:

DLookup("Signature", "Employees", "ProviderNumber = '" & provnum & "' and Password = '" & pass &"'")


<div>
<div class="content wysiwyg-content">
i need to do a dlookup using 2 variable so that i can call this from a function<br />
however i keep getting data mismatch errors<br />
this is what i have and both variables are strings<br />
DLookup(&quot;Signature&quot;, &quot;Employees&quot;, &quot;ProviderNumber = &quot;&nbsp;&amp; provnum &amp;&nbsp;&quot; and Password = &quot;&nbsp;&amp; pass)
</div>
</div>


i need to do a dlookup using 2 variable so that i can call this from a function
however i keep getting data mismatch errors
this is what i have and both variables are strings
DLookup("Signature", "Employees", "ProviderNumber = " & provnum & " and Password = " & pass)

Dlookup With 2 variable

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.