Unanswered: How can I get a message box to display if a user clicks a button on a form and left a
Both the command button and the field are on the same form (Form1). I want the user to fill in the blank, so if they leave it blank I want the command button to prompt a message box telling them to fill in the blank (rather than starting the code that the command button is actually for).
Here's the code I have behind the command button right now:
Private Sub cmd_PullQtOrd_Click()
If Forms!Form1.Text83.Value = Null Then
MsgBox.Show "Please enter your e-mail into into the Form1 textbox labeled 'User E-Mail'"
Null propagates. If used in an arithmetic or logic operation, or used in a comparison, the result will always be Null, while If expects the result of the evaluation expression be either True (-1) or False (0).