Refer to subform2 while on subform1... syntax??

[cmhoz]

Hello...

I have a form (main form) with a tabcontrol that houses a series of subforms.

What I'm trying to do: When I tick a box on "subform 1" (it has spaces in its name) I need controls on "subform 2" (again, has spaces) to become visible.

I have been trying to get my VBA syntax right and it's just not working. I've found a site (http://www.mvps.org/access/forms/frm0031.htm) that would seem to show me the way, but I've tried too many different versions and I can't get it right.

Help! Can anyone give me a sample of this syntax.

Thanks!

[dima69]

Hello...

I have a form (main form) with a tabcontrol that houses a series of subforms.

What I'm trying to do: When I tick a box on "subform 1" (it has spaces in its name) I need controls on "subform 2" (again, has spaces) to become visible.

I have been trying to get my VBA syntax right and it's just not working. I've found a site (http://www.mvps.org/access/forms/frm0031.htm) that would seem to show me the way, but I've tried too many different versions and I can't get it right.

Help! Can anyone give me a sample of this syntax.

Thanks!

Have you tried using

Forms("Main Form")![subform 2]![control 1].visible = True 

[nico5038]

Try:

Me.[subform 2].form.[control 1].visible = True

Nic;o)