I keep getting a "-2147352567You can't assign a value to this object." when it runs the below code at the Me.PIFCount = h area.
Else
'Count records per Customer Contract number 09/08/2011
rsCustTotals.MoveFirst
rsCustTotals.MoveLast
M = rsCustTotals.RecordCount
rsCustTotals.MoveFirst
Do While Not rsCustTotals.EOF
If rsCustTotals![Trans Type] = "N" Then
CustAmount = CustAmount + rsCustTotals![Loan Amount]
Else
End If
rsCustTotals.MoveNext
Loop
End If
rsQry.MoveNext
Loop
End If
If CustCount > 0 Then
Me.PIFCount = h
Else
Me.PIFAmount = 0
End If
If CustAmount > 0 Then
Me.PIFAmount = g
Else
Me.PIFAmount = 0
End If
I'm using Access 2003 report to calculate and add total to a textbox on the report. What am I doingggggggggg wrong?