form_Enabled-and-Locked.jpg

<div>
re:<br />
&quot;<b>Locked</b> - Yes (true) if user can modify contents of the control; No (false) if they cannot. &quot;<br />
<br />
I think Crystal meant: &nbsp;Yes (true) if user cannot modify the contents, No (false) if they can.
</div>


<div>
Dale -- yes!<br />
<br />
thank you<br />
<br />
Ken, -- correction:<br />
<b>Locked</b> - Yes (true) if user cannot modify contents of the control; No (false) if they still can ... of course, in order to be <i>able</i> to change anything (in the user interface; code can still do it), Enabled has to also be true<i> .. otherwise, &nbsp;Locked cannot even be evaluated if the user can't get into the control ...</i><br />
<br />
... tangential discussion bears consideration for other situations ...
</div>


<div>
Thanks to you both - Experts Exchange rocks! &nbsp;What a great resource.
</div>


<div>
you're welcome, Ken ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
I have a Form with Sub Form and Sub Sub Form. &nbsp;I would like the Visible Property of the sub sub form to be conditional on a field on the main form.<br />
<br />
QCInspect is a Yes/ No field on the main form. &nbsp;If QCInspect = yes, then Visible Property of Sub Sub Form = yes, otherwise &nbsp;Visible Property of Sub Sub Form = No.<br />
<br />
Thanks in advance for the assist.
</div>
</div>


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.

Conditional Sub Sub from Visible = No

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.