Error 2057 - Not enough stack memory left to perform this operation

[psycoperl]

I am getting a 2057 - Not enough stack memory left to perform this operation error when opening a form which as part of its FormLoad event calls the following.

We have the database setup as a frontend/backend set.

We have the front end loaded on 3 desktops.

Private Sub Form_Load()
    Call UpdateStudentStats
End Sub

Private Sub UpdateStudentStats()
    Me.txtToday = "As of: " & Format(Now, "DDD. MM/DD/YYYY HH:mm:ss")
    Me.txtStudentsCheckedIn = StudentsAttended
    Me.txtStudentsRemaining = StudentsStillTesting
    Me.Requery
End Sub

Function StudentsAttended() As Integer
    StudentsAttended = DLookup("count([ID])", "tblScannedQRCode", "[ScanInDateTime]>=Date() And [ScanInDateTime]<Date()+1")
End Function

 

[xenou]

Hi,

Very suspicious requery-ing a form in its Load event.

Also suspicious having a field named count([ID]). Not really something that should ever be a field name but I guess it's your choice. Better to stick to alphanumeric values only in field names - no spaces, no special characters.