Switch unvisible Subform to visible

[EZLI]

Hi,
How to switch unvisible subform placed in Form to visible
using Button.
Thank's in advance for help.

 

[OnTheFly]

Forms!MainFormName!SubFormName.Visible=True

Hope this helps.

OnTheFly

 

[EZLI]

Thank You OnTheFly.
It's working fine.

I have on more question.
I will try to hide subform content using CheckBox (placed on MainForm).
If ChekBox=True the subform must be unvisible.
How to do it?

Bob

 

[PHV]

In the AfterUpdate event procedure of the CheckBox:
Me![subform control name].Visible = Not Me!ChekBox
If the CheckBox is bound you may also consider the Current event procedure of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244