Can anybody please help????

I have a continuous sub form where I'm trying to change the background
colour of a text box called "Debriefed"

if the criteria is YES then I want the control to be GREEN
and RED if the criteria is NO

The code I have below works if I set the form to a single form however
it dosen't work if I set it to continuous

Private Sub Form_Current()
If [Debriefed] = "Yes" Then
[Debriefed].BackColor = vbGreen
Else
[Debriefed].BackColor = vbRed
End If
End Sub

Many thanks in advance