When a field in form (in this case txtArtist) is blank i want to be able to make it so they cant move on or aware that the field is blank. I wrote the following code but it doesnt seem to work properly, it works after i type a name in the field and then delete it and move on, it comes up with the message. But doesnt show any message if i tab right pass it.
After Update
Dim strMsg As String, strTitle As String
Dim intStyle As Integer
If IsNull(txtArtist) Or txtArtist = "" Then
strMsg = "You must enter Artists name."
strTitle = "Cant be blank"
intStyle = vbOKOnly
MsgBox strMsg, intStyle, strTitle
Cancel = True
End If
HeLP
cheers
After Update
Dim strMsg As String, strTitle As String
Dim intStyle As Integer
If IsNull(txtArtist) Or txtArtist = "" Then
strMsg = "You must enter Artists name."
strTitle = "Cant be blank"
intStyle = vbOKOnly
MsgBox strMsg, intStyle, strTitle
Cancel = True
End If
HeLP
cheers