How do I select the main form when the focus is on the subform?

[bcmarshall]

This should be simple...but it's proving to be vexing!

I know the syntax for referring to a control on a subform from the main form is [Forms]![FormName]![SubformName].[Form]![ControlName]. Is there a similar syntax that must be employed to do the reverse, to refer to a control on the main form from the subform? Forms!MainformName!ControlName does not work.

I've found several references while searching the web for a solution to the Me.Parent.Parent!ControlName syntax, but what I'm looking for is the full syntax that doesn't include the Me., something like [Forms]![MainformName] etc...

Help would be appreciated.

[pbaldy]

That syntax should work, but here's a reference:

http://access.mvps.org/access/forms/frm0031.htm

[bcmarshall]

I found the very same page you directed me to while searching. The problem is that I'm using macros and the Me. syntax doesn't work. If you have a form with a subform, give the Forms!MainformName!ControlName syntax a try and you'll see that it doesn't work at all! I was hoping for the reverse of [Forms]![FormName]![SubformName].[Form]![ControlName]

[pbaldy]

Forms!MainformName!ControlName will certainly work, and I've used it with many forms with subforms. Can you post the db here? I suspect something isn't what it seems to be.