Making a sub-subform visible / invisible

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.

If Forms!surveyGroup.survey.Form.surveyTypeID.Value = 2 Then
     MsgBox "is Land"
 
    Me!survey.Form!subform_LandSightings.Form.Visible = True
 
Else
    Me!survey.Form!subform_LandSightings.Form.Visible = False
End IF

Open in new window

davecocks

Asked: 2009-06-30

Advertise Here

1 Solution

LVL 75

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented: 2009-06-30

Try this:

Me.survey.Form.subform_LandSightings.Visible = True ' False

mx

LVL 1

davecocksAuthor Commented: 2009-06-30

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

LVL 75

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented: 2009-06-30

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

mx

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Making a sub-subform visible / invisible

Join & Write a Comment Already a member? Login.

Featured Post