Good afternoon,
I'm trying to create a report that does the following:
If the term "Other" is selected in the Time1 field, then the Time1 field will not be visible, but the field Other1 field will be visible and if the term "Other" is not selected in Time1 field, then the Time1 field will be visible and the Other1 field will not be. This is what I have for VBA code, but it is not working. Can anyone help me understand what I am doing wrong? Thanks!
If Not IsNull(Me.Time1) Then
If Me.Time1 = "Other" Then
Me.Time1.Visible = False
Else
Me.Time1.Visible = True
End If
Else
If Me.Time1 <> "Other" Then
Me.Other1.Visible = False
Else
Me.Other1.Visible = True
End If
End If
I'm trying to create a report that does the following:
If the term "Other" is selected in the Time1 field, then the Time1 field will not be visible, but the field Other1 field will be visible and if the term "Other" is not selected in Time1 field, then the Time1 field will be visible and the Other1 field will not be. This is what I have for VBA code, but it is not working. Can anyone help me understand what I am doing wrong? Thanks!
If Not IsNull(Me.Time1) Then
If Me.Time1 = "Other" Then
Me.Time1.Visible = False
Else
Me.Time1.Visible = True
End If
Else
If Me.Time1 <> "Other" Then
Me.Other1.Visible = False
Else
Me.Other1.Visible = True
End If
End If
If statement with multiple criteria
