Hi Guys,

I have a form of which one of the fields is a required field and just
wondering how/ where I put the code to present a message box if they fail to
enter a value. I was going to use:


If MsgBox("This is a required field, " & _
"Have you entered some details?.", vbYesNo) = vbYes Then
End If

But am unsure where I should place this? I am using a SQL BE with Access FE
and currently if the user tries to leave the field blank they get a very
unfriendly error message.

Can anyone advise please