Invalid use of Null??

[Xarkath]

Hello,



I had a small bit of code working last night but today when I resumed testing the form the following line of the code is now throwing the error: Invalid use of Null.

mbp = DMax("[ID]", "[Invoice Tracking]", "[Finalized Date] Is Not Null" & " AND [Group#]=" & """" & [Forms]![EnrlTracking_frm]![grp#] & """")

Any ideas why it started throwing that error? What I have found online so far suggests that it is a valid use of Null. And I have not yet made any changes this morning so it seems like it should be working as well today as it did yesterday.

Is there maybe a better way to write this line of code to simply avoid the error altogether?

Thanks

[June7]

What data type is mbp? Only Variant type variable can hold Null.

DMax will return Null if no match found.

mbp = Nz(DMax("[ID]", "[Invoice Tracking]", "[Finalized Date] Is Not Null" & " AND [Group#]=" & """" & [Forms]![EnrlTracking_frm]![grp#] & """"), 0)

[ranman256]

JUNE7 is right. You cant assign Nulls to other datatypes except variants.

[Xarkath]

That makes perfect sense. This was my oversight, the group used in the test has not had an invoice ran yet so it did produce a null value.

Thanks for the help. The people on this forum are AWESOME.