controls on subforms

[Chris]

Hello Group.

I have a form (frmMain) and on that form I have used the tab control- pge1,
pge2, pge3. On these pages I have subforms.

I would like the a checkbox on the subform on page1 to make the tab (pge2)
visible when ticked.

I'm have tried the following code;

'Forms!frmMain.pge2.Pages(1).Visible = Forms!sfrmsub1.chkbox.Value

Helping me can be your good deed for the day!

 

[Douglas J. Steele]

Keri Hardwick provides a good explanation at
http://www.mvps.org/access/forms/frm0031.htm at "The Access Web"

 

[StCyrM]

Hi Chris

The proper syntax to access the control on the subform would be as follows:

'Forms!frmMain.pge2.Pages(1).Visible = Forms!sfrmsub1.form!chkbox.Value

Best regards

Maurice St-Cyr
Micro Systems Consultants, Inc.