DLookUp function giving invalid use of null error

[shubhamgandhi]

Heres is a snippet of the code I'm trying to run, but I'm getting a run-time error "Invalid use of Null".

       ...
        Set fld_orders = rst_orders.Fields("ORDER")
        curOrder = fld_orders.Value

        Dim temp As String
        temp = DLookup("SKUS_ORDERED", "ORDER_DATA", "SKUS_ORDERED = " & curSKU2 & " AND [ORDER] = " & curOrder)

        If temp <> Null Then MsgBox temp
       ...

Where am I using null?
Can anyone help me out?

[pbaldy]

The String variable can't accept a Null, which presumably is what the DLookup is returning. Variant is the only data type that can accept a Null, so either use that or use the Nz() function when you set the variable.

[pbaldy]

By the way, this test can't be trusted:

If temp <> Null Then MsgBox temp

Use

If Not IsNull(temp) Then MsgBox temp

[shubhamgandhi]

I see, changing the type to Variant works.
That's odd tho, it shouldn't be returning null, the record exists, I know it does.
Any ideas on why it could be returning null?

[pbaldy]

Both data types in the criteria are numeric? Either set a breakpoint or use message boxes to check the contents of the variables. I'd point out that the field being looked up is the same as the one in the criteria, which seems odd (as in why bother). Perhaps the field in the criteria should be different?