Two SubForms and SetFocus

Dear,
I have trouble trying to setfocus to a text object in a second subform. I
have no problem setting focus to any text objects in the first level a
subform, but the subform within it, I failed.

Here is the scenario, say I have FORM_A from the beginning, which contains
a subform container, named SubFormContainerFirst, and this
SubFormContainerFirst is associated with FORM_B, and it has an text object
named Text_B
In FORM_B, I have the second subform container, named
SubFormContainerSecond, and this is associated with a form called FORM_C.

If I have a text object named Text_C in FORM_C,
Would you be able to show me how to setfocus to it?

My successful attempt to setfocus on Text_B which is from
SubFormContainerFirst is:
Forms!FORM_A.SubFormContainerFirst!Text_B.SetFocus

Please let me know if I am not making clear to my question.

Thank you for your assistance.
Martin

On Wed, 24 Aug 2005 10:22:04 -0700, Martin
wrote:

Dear,
I have trouble trying to setfocus to a text object in a second subform. I
have no problem setting focus to any text objects in the first level a
subform, but the subform within it, I failed.

Here is the scenario, say I have FORM_A from the beginning, which contains
a subform container, named SubFormContainerFirst, and this
SubFormContainerFirst is associated with FORM_B, and it has an text object
named Text_B
In FORM_B, I have the second subform container, named
SubFormContainerSecond, and this is associated with a form called FORM_C.

If I have a text object named Text_C in FORM_C,
Would you be able to show me how to setfocus to it?

My successful attempt to setfocus on Text_B which is from
SubFormContainerFirst is:
Forms!FORM_A.SubFormContainerFirst!Text_B.SetFocu s

Please let me know if I am not making clear to my question.

Thank you for your assistance.
Martin


It will take three SetFocus lines when run from FORM_A:

Me!SubFormContainerFirst.SetFocus
Me!SubFormContainerFirst.Form!SubFormContainerSeco nd.SetFocus
Me!SubFormContainerFirst.Form!SubFormContainerSeco nd.Form.Text_C.SetFocus
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

RG,
Thank you! It worked. Have a great day. Martin

"RuralGuy" wrote:

On Wed, 24 Aug 2005 10:22:04 -0700, Martin
wrote:

Dear,
I have trouble trying to setfocus to a text object in a second subform. I
have no problem setting focus to any text objects in the first level a
subform, but the subform within it, I failed.

Here is the scenario, say I have FORM_A from the beginning, which contains
a subform container, named SubFormContainerFirst, and this
SubFormContainerFirst is associated with FORM_B, and it has an text object
named Text_B
In FORM_B, I have the second subform container, named
SubFormContainerSecond, and this is associated with a form called FORM_C.

If I have a text object named Text_C in FORM_C,
Would you be able to show me how to setfocus to it?

My successful attempt to setfocus on Text_B which is from
SubFormContainerFirst is:
Forms!FORM_A.SubFormContainerFirst!Text_B.SetFocu s

Please let me know if I am not making clear to my question.

Thank you for your assistance.
Martin


It will take three SetFocus lines when run from FORM_A:

Me!SubFormContainerFirst.SetFocus
Me!SubFormContainerFirst.Form!SubFormContainerSeco nd.SetFocus
Me!SubFormContainerFirst.Form!SubFormContainerSeco nd.Form.Text_C.SetFocus
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

On Wed, 24 Aug 2005 12:57:03 -0700, Martin
wrote:

RG,
Thank you! It worked. Have a great day. Martin

You're very welcome. Glad I could help.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.