Hi Everyone,
My db has worked fine for well over a year and a half and today i receive the Run time error 28, out of stack space, i did not code the db nor no anything about it, below is the code and i have highlighted the section causing the problem according to the debugger, i hope you can help. It is access 2003,
Code:
Public Function UpdateCommission()
If Me.CommissionPayable1 = False Then
Me.CommissionDue = ([GrossOperatingProfit]) / 36 * 5
Else
Me.CommissionDue = 0
End If
Me.CommissionDue.Requery
End Function
Public Function UpdateCommission1()
If Me.CommissionPayable3 = False Then
Me.CommissionDue1 = ([GrossOperatingProfit]) / 2
Else
Me.CommissionDue1 = 0
End If
Me.CommissionDue1.Requery
End Function
Public Function UpdateCommission2()
If Me.CommissionPayable5 = False Then
Me.TelesalesCommission = 40
Else
Me.TelesalesCommission = 0
End If
Me.TelesalesCommission.Requery
End Function