hide/un-hide subforms ?

[piet123]

Please Help,

I have Mainfrm with 3 subfrms.

On Open of Mainfrm, the subfrms must have Hidden property.

I Have 3 CmdButtons on Mainfrm.
- Click button1 must Un-hide subfrm1.
- Click button2 must Hide subfrm1 and then Un-hide subfrm2.
- Etc.

Anyone ?

Thank you.
Piet.

 

[Ally]

You'll need the visible property. On the OpenEvent and CurrentEvent of the main form put:

Me.NameOfSubform1.Visible = False
Me.NameOfSubform2.Visible = False
Me.NameOfSubform3.Visible = False

I Have 3 CmdButtons on Mainfrm.
- Click button1 must Un-hide subfrm1.

OnClick of your command buttons put:
Me.NameOfSubform1.Visible = True etc etc

- Click button2 must Hide subfrm1 and then Un-hide subfrm2.
- Etc.

Me.NameOfSubform1.Visible = False
Me.NameOfSubform2.Visible = True

 

[piet123]

Got it! Thank you very much.

You'll need the visible property. On the OpenEvent and CurrentEvent of the main form put:

Me.NameOfSubform1.Visible = False
Me.NameOfSubform2.Visible = False
Me.NameOfSubform3.Visible = False


OnClick of your command buttons put:
Me.NameOfSubform1.Visible = True etc etc



Me.NameOfSubform1.Visible = False
Me.NameOfSubform2.Visible = True