<div>
Is Station or Solution are Text fields:<br />
<br />
DLookup(&quot;LotNumber&quot;,&quot;CM_SO<wbr />LUTION_USA<wbr />GE&quot;, &quot;[Station] = '&quot; &amp;&nbsp;[Forms]![Station Replenishment]![Station] &amp;&nbsp;&quot;' And [Solution] = &nbsp;'&quot; &amp;&nbsp;[Forms]![Station Replenishment]![cmbSolutio<wbr />n] &nbsp;&amp; &quot;' And IsNull([RemovedBy])&quot;)
</div>


Is Station or Solution are Text fields:

DLookup("LotNumber","CM_SOLUTION_USAGE", "[Station] = '" & [Forms]![Station Replenishment]![Station] & "' And [Solution] =  '" & [Forms]![Station Replenishment]![cmbSolution]  & "' And IsNull([RemovedBy])")

<div>
[Station] is a number, [Solution] is a text and [RemovedBy] is a text.
</div>


[Station] is a number, [Solution] is a text and [RemovedBy] is a text.

<div>
Thank you Scott but it does not work yet, I get error Run-time 3464.
</div>


Thank you Scott but it does not work yet, I get error Run-time 3464.

<div>
<div class="content wysiwyg-content">
Hello all, <br />
<br />
I can not figure out what I am doing wrong with this syntax. I know that I am screwing thing up when filtering data [RemovedBy] for Null only data. My guess is that I am missing or miss placed quotation marks. Help!!!!<br />
<br />
DLookup(&quot;LotNumber&quot;,&quot;CM_SO<wbr />LUTION_USA<wbr />GE&quot;, &quot;[Station] = &quot;&nbsp;&amp; [Forms]![Station Replenishment]![Station] &amp;&nbsp;&quot; And [Solution] = &nbsp;&quot; &amp;&nbsp;[Forms]![Station Replenishment]![cmbSolutio<wbr />n] &nbsp;&amp; &quot;&nbsp;And [RemovedBy]Is Null&quot;)<br />
<br />
Thank you!!!
</div>
</div>


Hello all, 

I can not figure out what I am doing wrong with this syntax. I know that I am screwing thing up when filtering data [RemovedBy] for Null only data. My guess is that I am missing or miss placed quotation marks. Help!!!!

DLookup("LotNumber","CM_SOLUTION_USAGE", "[Station] = " & [Forms]![Station Replenishment]![Station] & " And [Solution] =  " & [Forms]![Station Replenishment]![cmbSolution]  & " And [RemovedBy]Is Null")

Thank you!!!

Ms Access DLookup with multi criteria and a Null value

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.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.