Hi All,
Please could you assist
I have a form with multiple scenarios
2 buttons, if another control is =1 then one button must be visable, if 2 then show other button
also, if any of other controls are null, dont show any of the 2 buttons
The 2 codes below are conflicting each other
my code:
#
Private Sub Form_Current()
If Me.Defered = "1" Then
Me.SaveDefer.Visible = True
Me.Savesignoff.Visible = False
Else
Me.SaveDefer.Visible = False
Me.Savesignoff.Visible = True
End If
If IsNull(Me.CrewChief) Or (IsNull(Me.AME)) Or (IsNull(Me.DualInspector)) Or (IsNull(Me.Defered)) Then
Me.Savesignoff.Visible = False
Me.SaveDefer.Visible = False
Else
Me.Savesignoff.Visible = True
Me.SaveDefer.Visible = True
End If
End Sub#
Please could you assist
I have a form with multiple scenarios
2 buttons, if another control is =1 then one button must be visable, if 2 then show other button
also, if any of other controls are null, dont show any of the 2 buttons
The 2 codes below are conflicting each other
my code:
#
Private Sub Form_Current()
If Me.Defered = "1" Then
Me.SaveDefer.Visible = True
Me.Savesignoff.Visible = False
Else
Me.SaveDefer.Visible = False
Me.Savesignoff.Visible = True
End If
If IsNull(Me.CrewChief) Or (IsNull(Me.AME)) Or (IsNull(Me.DualInspector)) Or (IsNull(Me.Defered)) Then
Me.Savesignoff.Visible = False
Me.SaveDefer.Visible = False
Else
Me.Savesignoff.Visible = True
Me.SaveDefer.Visible = True
End If
End Sub#