jeran042
Registered User.
- Local time
- Today, 05:17
- Joined
- Jun 26, 2017
- Messages
- 127
I have an error that I can use some help on:
I have an unbound textbox that performs a dlookup. The formula looks like this:
This works fine until there is no [VOUCHER_NUMBER] to look up. I then get a #Type! Error.
I would have thought that the Nz would negate this error (apparently I am wrong).
What can I do mitigate the error so I don’t see the #Type! Error
I have an unbound textbox that performs a dlookup. The formula looks like this:
Code:
=Replace(Nz(DLookUp("tblInvoiceLog.NOTES","tblInvoiceLog","[VOUCHER_NUMBER]= " & [txtADJ_POLICY] & ""),""),Chr(13) & Chr(10)," ")
I would have thought that the Nz would negate this error (apparently I am wrong).
What can I do mitigate the error so I don’t see the #Type! Error