Timer Event Problem

[Novice1]

I have a simple form. In the form I have a field =Count([LName]) which is used to count the number of people in the record source (query). I also change the format for the field to General Number. This works fine. The problem I'm having is using a timer event. I cannot recall the result in the IF/Then statement.

FYI: I placed MsgBox [CountQueue] after the requery but the result is blank.

Here's the timer event.

DoCmd.Requery

If Me.CountQueue = "0" Then

Me![LabelC].ForeColor = vbBlack

Else

Me![LabelC].ForeColor = vbRed

Call PlayWaveFile("M:\MPF\SignInPlus\SignInTool\notify2.WAV")

End If

 

[pbaldy]

Does dropping the quotes work?

If Me.CountQueue = 0 Then