S
SHIPP
I have the following code:
Dim strTest As String
strTest = DLookup("[UPCFip13]", "tblPromo", "#" & dteSched & "# between " _
& "[StartDate] and [EndDate] and [UPCFip13]=" & Chr(34) & strUPC &
Chr(34))
If strTest = Null Then
IdentifyPromo = ""
Else
IdentifyPromo = "P"
End If
When dlookup doesn't fine a matching record it gives me error 93 invalid use
of null. Any ideas?
Dim strTest As String
strTest = DLookup("[UPCFip13]", "tblPromo", "#" & dteSched & "# between " _
& "[StartDate] and [EndDate] and [UPCFip13]=" & Chr(34) & strUPC &
Chr(34))
If strTest = Null Then
IdentifyPromo = ""
Else
IdentifyPromo = "P"
End If
When dlookup doesn't fine a matching record it gives me error 93 invalid use
of null. Any ideas?