DLookup error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

If UserClearedItem is Null it will error.

How do I fix that?

Thank you,

Steven
 
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
 
Back
Top