Hello all. Thank you for putting up with my first post on here. And thank you for all the help you have already given me through other posts that I have read.
I have looked around, and I can't find what I am looking for. I am hoping you can give me some advice.
I have a label on an Access form that I want to remain hidden, unless a specific checkbox is checked.
I have everything I need worked out, except keeping it hidden. Here is the code that I have so far. The second 1/2 of the code does exactly what I would like it to do, with the exception that it doesn't work on a continous form, but I am not worried about that.
Private Sub Form_Activate()
If Me.Weapon.Value = True Then
Me.Label30.Visible = True
Else
If Me.Weapon.Value = False Then
Me.Label30.Visible = False
End If
End If
End Sub
Private Sub Form_Timer()
If Me.Weapon = True Then
Me.Label30.Visible = Not Me.Label30.Visible
Else
If Me.Weapon = False Then
End If
End If
End Sub
I have looked around, and I can't find what I am looking for. I am hoping you can give me some advice.
I have a label on an Access form that I want to remain hidden, unless a specific checkbox is checked.
I have everything I need worked out, except keeping it hidden. Here is the code that I have so far. The second 1/2 of the code does exactly what I would like it to do, with the exception that it doesn't work on a continous form, but I am not worried about that.
Private Sub Form_Activate()
If Me.Weapon.Value = True Then
Me.Label30.Visible = True
Else
If Me.Weapon.Value = False Then
Me.Label30.Visible = False
End If
End If
End Sub
Private Sub Form_Timer()
If Me.Weapon = True Then
Me.Label30.Visible = Not Me.Label30.Visible
Else
If Me.Weapon = False Then
End If
End If
End Sub