Why do I have to click on the field for the value to display

[jvelezc]

I dont understand why in my report the value for attendance has to be clicked before it displays.
I tried this:

Private Sub Text11_Enter()
Dim present As String


present = DLookup("[counter]", "Query2")
If IsNull(Me!attendance) Then
attendace.Value = present
attendace.Text = present
End If
End Sub
To donwload the database in question:
http://www.caltutorcentral.com/test/Database1.accdb

[RuralGuy]

Are you talking about a form because a report is not interactive? The event you have this code in *only* executes when you move the focus to that control.

[azal]

Dcount for form, because it is RUNNING count...

use to count attendence:

give attendance cases CODES in the database for example present (1) and abs (2)

and in attenedance textbox type this:

=sum(iif(attendance=1; 1;0))


hope it helps