Macro to navigate to tab or subform

[larrydwilliams]

I am trying to get an "on click" macro to move from one sub-form to another. This doesn't seem like it should be very difficult, but error messages indicate that the form isn't open or that access can't locate the specific subform. I have tried all kinds of forms!masterform.form!subform down to just the subform name itself (which opens the subform in a new window -- not what I'm after).



Can anyone give me the macro commands that will get me to the desired location?

[June7]

I always name subform container control different from the object it holds, like ctrDetails.

Then use code to set focus on the subform container control.