DLookup error

S

Steven

vName = Nz(DLookup("UserName", "Users", "Order = " & UserClearedItem), "")

If UserClearedItem is Null it will error.

How do I fix that?

Thank you,

Steven
 
B

BeWyched

Hi

Try moving the Nz and include 's if UserClearedItem is a String:

vName = DLookup("UserName", "Users", "Order = '" & Nz(UserClearedItem) & "'")

Note that '" is, exagerated, ' " and "'" is " ' ".

BW
 
Top