Unanswered: If statements to look at more than 1 field
I have a button on a form that closes it and opens another. At the moment I have code in there to check that the user has entered data into a field called "Address1". Does anyone know how to get it to check other fields within the same piece of code - specifically in this case "Address2", i.e.
If address1 is null OR if address2 is null then...
The code I have used to check the single field is:
Private Sub labelProjects_Click()
If IsNull(Me.address1) Then
MsgBox "Please enter data for Address1"
DoCmd.Close acForm, "frmAddPerson"
DoCmd.Close acForm, "PROJECTS2"
DoCmd.OpenForm "PROJECTS2", acNormal, "", "", , acNormal