I cannot see my error. I am getting error# 94, invalid use of null with the following dlookup line:
The first line works correctly with n1(jk) = 137, so obviously [nettot] isn't null.
Any insight would be appreciated!
Code:
n1(jk) = DMin("[nettot]", "flcalc", "[fl] = " & jk & _
" AND [tp] = " & Chr(34) & var & Chr(34) & " OR [tp] = " & Chr(34) & x & Chr(34))
Dim lkup As String
lkup = DLookup("[tp]", "flcalc", "[fl] = " & jk & " AND [nettot] = " & n1(jk))
The first line works correctly with n1(jk) = 137, so obviously [nettot] isn't null.
Any insight would be appreciated!