Code for IsNull value in a DLookup statement

[kevin]

Hi,

I have some code that looks up the value of a field in a table using the
DLookup function. However if the field has a Null Value the code returns an
error.

Could you tell me what the IsNull code should be?

[Payment Method] = DLookup("[Default Payment Method]", "tblSuppliers",
"[SupplierID]=" & [Supplier] & "")

 

[Dennis]

If you want zero to be returned then try this

[Payment Method] = Nz(DLookup("[Default Payment Method]", "tblSuppliers",
"[SupplierID]=" & [Supplier]),0)

 

[Gijs Beukenoot]

From Dennis :

If you want zero to be returned then try this

[Payment Method] = Nz(DLookup("[Default Payment Method]", "tblSuppliers",
"[SupplierID]=" & [Supplier]),0)

Hi,

I have some code that looks up the value of a field in a table using the
DLookup function. However if the field has a Null Value the code returns an
error.

Could you tell me what the IsNull code should be?

[Payment Method] = DLookup("[Default Payment Method]", "tblSuppliers",
"[SupplierID]=" & [Supplier] & "")

I think Kevin, that he means the [Supplier] field:

[Payment Method] = DLookup("[Default Payment Method]", "tblSuppliers",
"[SupplierID]=" & Nz([Supplier],"") & "")