Need language for IsNotNull

[doerfohio]

Here's what I have, but the IsNotNull part isn't right. If I change it to IsNull, everything works well, But I only want this message box to appear if the Staff Name field is NOT blank.

TIA!

If IsNotNull(On_The_Clock_subform.Staff_Name) Then
response = MsgBox("You already punched in. Please punch out! ", vbOKOnly)
If response = 1 Then
Exit Sub
End If
End If

 

[jrbarnett]

If Not IsNull(On_The_Clock_subform.Staff_Name) Then

John

 

[doerfohio]

Thank you! Works great now.

~Dori