M
Marianne
Hello!
I had a previous post on this but have narrowed my troubles to this line.
Why am I getting the Error 94 Invalid use of Null on the line of code for
the curPymtsByLine?
the locals window shows all the correct values for each variable.
Dim lngInvID As Long
Dim lngLineNum As Long
Dim curPymtsByLine As Currency
lngInvID = Nz(Me.PymtInvID)
lngLineNum = Nz(Me.InvLineNum)
***curPymtsByLine = DSum("[Pymt]", "PaymentDetail", "[PymtInvID]= " &
lngInvID & [InvLineNum] = lngLineNum)
As always, thanks for the help!
I had a previous post on this but have narrowed my troubles to this line.
Why am I getting the Error 94 Invalid use of Null on the line of code for
the curPymtsByLine?
the locals window shows all the correct values for each variable.
Dim lngInvID As Long
Dim lngLineNum As Long
Dim curPymtsByLine As Currency
lngInvID = Nz(Me.PymtInvID)
lngLineNum = Nz(Me.InvLineNum)
***curPymtsByLine = DSum("[Pymt]", "PaymentDetail", "[PymtInvID]= " &
lngInvID & [InvLineNum] = lngLineNum)
As always, thanks for the help!