Set the controls to visible

[kev]

Hi folks,

Hope you guys can help.
I have a form"frmSafetyLevel1" in which users will enter data and once
they submit, the results will be displayed on "frmSL1Registration". My
problem here is i need to set some controls in the "frmSL1Registration"
to invisible if the control does not have a value "Passed, Not
Applicable, Yes or No".

The reason why i have controls without values is beacuse of this
sceanario below:
3. During all operations, troubleshooting and PMs, are all hazardous
energies locked-out, blocked, or isolated, whenever an employee has an
arm, hand, or other body part inside a "Danger Zone"?

The answer to this question will be a Yes or No. If they select Yes,
then question 4 will not need to be answered. Only if the answer is No,
they will proceed to Question 4
4. If the answer above is NO, has a normal production operations (NPO)
been submitted and approved by the NPO board.

So now i hope you got the idea right. How do i set the control for
Question(4) to be invisible in "frmSL1Registration" if it is not
answered.

Many thanks in advance folks:)
Hoping for a quick reply.

[Don Barton]

Hi Kev,
To answer your question directly, you could use an
IF, THEN, END IF scenario in the control's Before Update event:

If Forms!frmSafetyLevel1.mycontrol = "Yes" (or whatever criteria you
are testing for) then
Me!frmSL1Registration.mycontrol.Visible=True
Else
Me!frmSL1Registration.mycontrol.Visible=False
End if

Hope this helps,
Don

On Dec 13, 9:17 pm, "kev" <[e-mail]:

Hi folks,

Hope you guys can help.
I have a form"frmSafetyLevel1" in which users will enter data and once
they submit, the results will be displayed on "frmSL1Registration". My
problem here is i need to set some controls in the "frmSL1Registration"
to invisible if the control does not have a value "Passed, Not
Applicable, Yes or No".

>
So now i hope you got the idea right. How do i set the control for
Question(4) to be invisible in "frmSL1Registration" if it is not
answered.

Many thanks in advance folks:)
Hoping for a quick reply.