Access Dlookup help 2

[johnfra]

Hi All<br>
I am having a major problem using the DLookup function in a query. I can enter the expr and domain with no problem, but when I enter the criteria, I get an error that Access cant find the criteria.<br>
<br>
Colour: DLookUp(&quot;[color]&quot;,&quot;ColorCodeTable&quot;,&quot;[Colorcodes]=[TestValue]&quot<br>
<br>
Using this statement, I get an error that Access can't find &quot;TestValue&quot;. TestValue is a field in the current Query.<br>
<br>
As always any help would be greatly appreciated.<br>
<br>
Best Regards,<br>
John

 

[Jonathan]

Try:<br>
<br>
DLookUp(&quot;[color]&quot;,&quot;ColorCodeTable&quot;,&quot;[Colorcodes]=&quot; & [TestValue])<br>
<br>
Jonathan