asked on

Conditional Sub Sub from Visible = No

I have a Form with Sub Form and Sub Sub Form. I would like the Visible Property of the sub sub form to be conditional on a field on the main form.

QCInspect is a Yes/ No field on the main form. If QCInspect = yes, then Visible Property of Sub Sub Form = yes, otherwise Visible Property of Sub Sub Form = No.

Thanks in advance for the assist.

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

crystal (strive4peace)

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Dale Fye

re:
"Locked - Yes (true) if user can modify contents of the control; No (false) if they cannot. "

I think Crystal meant: Yes (true) if user cannot modify the contents, No (false) if they can.

crystal (strive4peace)

Dale -- yes!

thank you

Ken, -- correction:
Locked - Yes (true) if user cannot modify contents of the control; No (false) if they still can ... of course, in order to be able to change anything (in the user interface; code can still do it), Enabled has to also be true .. otherwise, Locked cannot even be evaluated if the user can't get into the control ...

... tangential discussion bears consideration for other situations ...

Ken Milam

ASKER

Thanks to you both - Experts Exchange rocks! What a great resource.

crystal (strive4peace)

you're welcome, Ken ~ happy to help