display/hide subforms

[Weresmytriple]

hi

i have created a form with 3 subforms on. i was just wondering is it possible to display/ hide these subforms based on a Yes/No field in the form. as the subforms would only be valid if the field is ticked as yes.

thanks for any help

michael

 

[pr2-eugin]

Hello Weresmytriple, It sure is possible, BUT a word of caution to this tale. You will have empty spaces in the Form if they are hidden, might not be looking great.. Is that something you would want to go ahead with?

It might look something like..

 

[Weresmytriple]

yes im sure. the final display isnt important, its more important that it functions correctly. so far i have coded an on click event

Private Sub CQC_Click()
If CQC = Yes Then
        CQC_Subform.Visible = True
        Else
        CQC_Subform.Visible = False
        
End If
End Sub

however this is doing the exact opposite of what i need. it is hiding the subform when checked and unhiding it when unchecked

thanks for the help

 

[Weresmytriple]

just switched the true and false around and its working now

 

[pr2-eugin]

Instead of Yes try True/False.. If you want it also to do when the Form is opened you might need to have the same code in the Form Current method..

Also just for the fun of it, you can do it in one single line.

Private Sub CQC_Click()
    CQC_Subform.Visible = Me.CQC
End Sub

Private Sub Form_Current()
    CQC_Subform.Visible = Me.CQC
End Sub

 

[pr2-eugin]

Oh forgot to say, you can add the Sub Form's in separate tabs.. This way when you Hide them you can save the bizarre gap in the Form..

 

[Weresmytriple]

what do you mean seperate tags?

 

[pr2-eugin]

Not tags.. taBs.. Like..

 

[Weresmytriple]

yeah sorry that was a typo. how would i go about creating the tabs? as that would be really useful.

thanks

 

[pr2-eugin]

Here is a LINK on how to create a tabbed form..

 

[Weresmytriple]

thanks for all your help

 

[pr2-eugin]

You are welcome, post back if you are stuck. Good Luck.

 

[Weresmytriple]

how do you insert/merge a subform into the tabs?

 

[pr2-eugin]

You first create the tab in the current form then just cut the SubForm from there and put it into the tab..

 

[Weresmytriple]

thanks once again. i appreciate your time and patients with me

 

[pr2-eugin]

No problemo !

 

[Weresmytriple]

them tabs was a brilliant idea. they are working great

 

[pr2-eugin]

Glad to be of assistance..