<div>
Perfect!!!! &nbsp; That's been driving me nuts!!!
</div>


Perfect!!!!   That's been driving me nuts!!!

<div>
You were close. &nbsp;The last 'Form' reference is not required. &nbsp;That's only needed if you were referring to a control on the sub-sub form.<br />
<br />
See this link for the ultimate reference in form/subform ... report/subreport systax<br />
<br />
<a href="http://www.mvps.org/access/forms/frm0031.htm" rel="ugc">http://www.mvps.org/access/forms/frm0031.htm</a><br />
<br />
mx
</div>


You were close.  The last 'Form' reference is not required.  That's only needed if you were referring to a control on the sub-sub form.

See this link for the ultimate reference in form/subform ... report/subreport systax

http://www.mvps.org/access/forms/frm0031.htm [http://www.mvps.org/access/forms/frm0031.htm]

mx

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Form: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;groupSurvey<br />
subform &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;survey<br />
sub-subform: &nbsp; &nbsp; &nbsp;subform_landSightings<br />
<br />
I'm trying to make a sub sub-form visible / invisible from a button click on the main form.<br />
<br />
subform_landSightings is a subform of survey.<br />
<br />
The code below gives this &nbsp; &nbsp; &nbsp; ERROR: &nbsp; <br />
<br />
Run time error 2455 &nbsp; <br />
&nbsp;You entered an expression that has an invalid reference to the property Form/Report<br />
<br />
Thanks.<br />
<br />

<pre><code id="code-355355">If Forms!surveyGroup.survey.Form.surveyTypeID.Value = 2 Then
     MsgBox &quot;is Land&quot; 
    Me!survey.Form!subform_LandSightings.Form.Visible = True 
Else
    Me!survey.Form!subform_LandSightings.Form.Visible = False
End IF
</code></pre>
</div>
</div>


Hi,

Form:                  groupSurvey
subform              survey
sub-subform:      subform_landSightings

I'm trying to make a sub sub-form visible / invisible from a button click on the main form.

subform_landSightings is a subform of survey.

The code below gives this       ERROR:   

Run time error 2455   
 You entered an expression that has an invalid reference to the property Form/Report

Thanks.


Making a sub-subform visible / invisible

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.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.