Error 28 Out of Stack Space

[loulou]

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,

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

[RuralGuy]

I do not see anything inherently flawed with the code you posted other than the minor issue with nothing is being returned by the function. Your issue is more than likely with the code that invokes this function perhaps too often.