I typically use a submit button and in the onclick event will be code like this:
If IsNull(YourControlName) Then
MsgBox "You have to choose something in the YourControlName field!", , "Incomplete Form!"
YourControlName.SetFocus
End If
I typically use a submit button and in the onclick event will be code like this:
If IsNull(YourControlName) Then
MsgBox "You have to choose something in the YourControlName field!", , "Incomplete Form!"
YourControlName.SetFocus
End If
I have the same thing on my forms. However, another way I have tried to help the user, is to make the background of the required field a pale yellow color. That is also a visual way for them to know it is required outside of the validation code listed above