J
Jimbo213
I have six Yes/No check boxes which give values of -1 and 0 respectively.
When any is -1 "On" I turn a work field [TestInSystem] to -1 "On"
When all are off I turn the same work field [TestInSystem] to 0
That work field logic is working just fine.
I am having trouble setting visible=False/True for 2 controls based on the
value in this work field [TestInSystem]
I suspect that On Change won't work unless you manually change the
[TestInSystem] value - and it is changing behind the scene.
Here is the code I'm using:
Private Sub TestInSystem_Change()
'
If Me.TestInSystem = -1 Then ' "Yes" condition
Me.Text1169.Visible = True
FrameStatusWAVE.Visible = True
Else
Me.Text1169.Visible = False ' "No" condition
FrameStatusWAVE.Visible = False
End If
'
End Sub
I'd appreciate a boot in the right direction.
Thanks for your reply & assistance.
Jimbo213
When any is -1 "On" I turn a work field [TestInSystem] to -1 "On"
When all are off I turn the same work field [TestInSystem] to 0
That work field logic is working just fine.
I am having trouble setting visible=False/True for 2 controls based on the
value in this work field [TestInSystem]
I suspect that On Change won't work unless you manually change the
[TestInSystem] value - and it is changing behind the scene.
Here is the code I'm using:
Private Sub TestInSystem_Change()
'
If Me.TestInSystem = -1 Then ' "Yes" condition
Me.Text1169.Visible = True
FrameStatusWAVE.Visible = True
Else
Me.Text1169.Visible = False ' "No" condition
FrameStatusWAVE.Visible = False
End If
'
End Sub
I'd appreciate a boot in the right direction.
Thanks for your reply & assistance.
Jimbo213