Dlookup problem

[crowegreg]

Hello,


Here is one dlookup statement that works properly:
DLookup("FirstName", "1_Customer", "TimeCreated=#3/17/2014 3:03:11 PM#")

This one produces the message of invalid use of null:
DLookup("FirstName", "1_Customer", "ListID='800007BE-1403477054'")

ListID is a text field, while TimeCreated is a date field.

What am I doing wrong?

[CJ_London]

if dlookup doesn't find a match it will return null, so I suspect it is something you are doing with the value dlookup returns which does not handle nulls

try something like

nz(DLookup("FirstName", "1_Customer", "ListID='800007BE-1403477054'"),"ListID not found")

[Missinglinq]

I see nothing wrong in your syntax, but DLookup returns a Null if no Records fit the Criteria or if the Domain, 1_Customer, in this case, contains no Records.

Linq ;0)>

[crowegreg]

Thank you. You both provided me with the solution.