Solved Show Hide sub Form

[Teri Bridges]

I want to show/Hide my sub form. when the user clicks the button the subform displays and when they click again it hides
I cannot get any of these to work
'Hide It
Forms!frmCourseDetails!frmCourseReviewCycleSubform.Visible = False
'Show it
Forms!frmCourseDetails!frmCourseReviewCycleSubform.Visible = True

This does not work either
Private Sub btnOpenReviewCycle_Click()
If Me.frmCourseReviewCycleSubform = False Then

Me.frmCourseReviewCycleSubform = True

ElseIf Me.frmCourseReviewCycleSubform = True Then

Me.frmCourseReviewCycleSubform = False

End Sub

 

[arnelgp]

maybe try:

Private Sub btnOpenReviewCycle_Click()
With Me!frmCourseReviewCycleSubform.Form
   .Visible = Not .Visible
End With
End Sub

 

[Teri Bridges]

Tried that and get the same error

 

[arnelgp]

you bring your main form in design view.
click on the subform in question and see it's Name on the Property window.
substitute the "Real Name" to frmCourseReviewCylemSubform in your code.

 

[Teri Bridges]

you bring your main form in design view.
click on the subform in question and see it's Name on the Property window.
substitute the "Real Name" to frmCourseReviewCylemSubform in your code.

Yes I checked that.

 

[Teri Bridges]

Yes I checked that.
View attachment 100239

Yes I checked that.
View attachment 100239

I Finally got it. I deleted the sub form and reinserted it and now works fine. Very odd. Thank you so much for the help.

 

[arnelgp]

ok, you got it.
but on the snapshot you showed, it is not the Caption i am refering.
if you go to the "Other" tab, and you will see it's Name property.

 

[Teri Bridges]

ok, you got it.
but on the snapshot you showed, it is not the Caption i am refering.
if you go to the "Other" tab, and you will see it's Name property.

Humm. I do not see that on the other tab.

 

[arnelgp]

try it again. click anywhere the form but the subform.
now try clicking on the Border of the subform, until a Yellow-Orange line/Box surrounds it.
go and see it's Name on the property sheet.

 

[Teri Bridges]

Humm. I do not see that on the other tab.
View attachment 100240

Geezs ole Peety! I did not know I could do THAT! What a big help that is going to be!!! THANK YOU!

 

[Gasman]

I would have thought you would need to use the name of the subform control? That is the same name as the form when you add the subform, which you have just done?

 

[Teri Bridges]

I would have thought you would need to use the name of the subform control? That is the same name as the form when you add the subform, which you have just done?

I had eariler changed the name of the form and thought I had updated it everywhere. But I did not know about the other tab check. I am sure that is why I was getting the code errors. When I deleted the sub form and added it back (New Name) it worked. These are my rookie mistakes.

 

[Gasman]

I always prefixed the subform control name with sfrm, so as to be able to distinguish between control and form, once I found this out.
Same with subreport, srpt

 

[Teri Bridges]

I always prefixed the subform control name with sfrm, so as to be able to distinguish between control and form, once I found this out.
Same with subreport, srpt

Good Idea. I have been adding subform to the end but using the "s" would shorten things up and make sorted. Thanks.

 

[ipsummedicare]

Good Idea. I have been adding subform to the end but using the "s" would shorten things up and make sorted. Thanks.

Absolutely