Unanswered: Null and not Null parameters into an If statement
I hope someone can help me. I need the code below to run only if the field "Surname" is NOT null AND “address1” OR “address2” is null.
Any ideas of how to incorporate null and not null parameters into an If statement?
Private Sub labelProjects_Click()
If IsNull(Me.address1) Or IsNull(Me.address2) Then
MsgBox "Please enter data for Address1 AND Address2"
DoCmd.Close acForm, "frmAddPerson"
DoCmd.Close acForm, "PROJECTS2"
DoCmd.OpenForm "PROJECTS2", acNormal, "", "", , acNormal