Quick and probably quite simple Invalid Use of Null Aftermath Ques

T

Tal

Hi all and thanks in advance for all your help.

So, I had a invalid use of Null error happening with a stack of DLookups,
which I solved with the Nz function, as exampled below:

dlookClientFirstName = Nz(DLookup("[txtClientFirstName]", "tblClients",
"[keyClient] = " & Me.Parent!keyClient), "")
dlookClientLastName = Nz(DLookup("[txtClientLastName]", "tblClients",
"[keyClient] = " & Me.Parent!keyClient), "")


However, now my whole RowSource blurb doesn't work properly because it was
dependent on the Nulls, as exampled below (don't worry that there are more
fields referenced here than I included above:

If IsNull(dlookClientLastName) = False Then
strReceiptTo = strReceiptTo & dlookClientFirstName & " " &
dlookClientLastName & ";"
End If
If IsNull(dlookCompanyOnly) = False Then
strReceiptTo = strReceiptTo & dlookCompanyOnly & ";"
End If
If IsNull(dlookSpouseFirstName) = False Then
strReceiptTo = strReceiptTo & dlookSpouseFirstName & " " &
dlookClientLastName & ";"
strReceiptTo = strReceiptTo & dlookClientFirstName & " or " &
dlookSpouseFirstName & " " & dlookClientLastName & ";"
End If

So now I am left with all kinds of empty and partial rows in my dropdown.
So, how do I rewrite the If... statement to reflect the new value of ""
instead of Null.

Again, thanks in advance.

Tal
 
C

Chegu Tom

Tal

the if IsNull(dlookclientlastname) will never work, because they will never
be nulls it always be false (because you used NZ the nulls will be converted
to empty strings "" )

use instead If dlookClientLastName <>"" then

Tom
 
T

Tal

Hi Chegu Tom,

That was exactly what I needed. Thank you!!

Cheers,
Tal

Chegu Tom said:
Tal

the if IsNull(dlookclientlastname) will never work, because they will never
be nulls it always be false (because you used NZ the nulls will be converted
to empty strings "" )

use instead If dlookClientLastName <>"" then

Tom

Tal said:
Hi all and thanks in advance for all your help.

So, I had a invalid use of Null error happening with a stack of DLookups,
which I solved with the Nz function, as exampled below:

dlookClientFirstName = Nz(DLookup("[txtClientFirstName]", "tblClients",
"[keyClient] = " & Me.Parent!keyClient), "")
dlookClientLastName = Nz(DLookup("[txtClientLastName]", "tblClients",
"[keyClient] = " & Me.Parent!keyClient), "")


However, now my whole RowSource blurb doesn't work properly because it was
dependent on the Nulls, as exampled below (don't worry that there are more
fields referenced here than I included above:

If IsNull(dlookClientLastName) = False Then
strReceiptTo = strReceiptTo & dlookClientFirstName & " " &
dlookClientLastName & ";"
End If
If IsNull(dlookCompanyOnly) = False Then
strReceiptTo = strReceiptTo & dlookCompanyOnly & ";"
End If
If IsNull(dlookSpouseFirstName) = False Then
strReceiptTo = strReceiptTo & dlookSpouseFirstName & " " &
dlookClientLastName & ";"
strReceiptTo = strReceiptTo & dlookClientFirstName & " or " &
dlookSpouseFirstName & " " & dlookClientLastName & ";"
End If

So now I am left with all kinds of empty and partial rows in my dropdown.
So, how do I rewrite the If... statement to reflect the new value of ""
instead of Null.

Again, thanks in advance.

Tal
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Use of Null on Function parameters 2
Invalid Use of Null 5
Invalid use of Null 7
invalid use of null 4
Invalid Use of Null - After Update 2
Help with Invalid Use of NULL and Dsum function 3
Dlookup invalid use of null 6
DLookUp Invalid Use of NUll 8

Top