Referencing a Subform

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ragazzo
    New Member
    • May 2007
    • 6

    #46
    How I seen in the Atachments it is two childs inside same form with Tabs adapted

    I tried one solution and worked well..


    1.MAIN FORM on Tab_Click set >> Me.ChildName.Se tfocus
    2.Second Form - On Load set >> Me.ChildName.Se tfocus
    3.Third Form - On Load set >> Me.TextName.Set focus

    ChildName and TextName bring what Yours are.
    and Tab Name As Yours
    Those condittion bring focus in the Text Box Of Third Loaded form.

    Regards


    Originally posted by Scott Price
    Attachment deleted, as per warning posted.

    Comment

    • Scott Price
      Recognized Expert Top Contributor
      • Jul 2007
      • 1384

      #47
      Ragazzo,

      Your example has very little value since you disabled all menu items, and blocked access to the code of your database sample.

      I have deleted the attachment since there is no way of verifying whether you have included possibly malicious code.

      MODERATOR

      Comment

      • ragazzo
        New Member
        • May 2007
        • 6

        #48
        Sorry for that...

        Aplication was dedicated for something else i just adapted for purpose of what

        it`s asked in this topic and forgot to prepare everything for simple use...

        I am sorry for this and I post again after I have make it very simple.


        Regards
        Ragazzo
        Attached Files

        Comment

        • Proaccesspro
          New Member
          • Apr 2007
          • 132

          #49
          Scott,

          I sent the DB to you.......

          Comment

          • Proaccesspro
            New Member
            • Apr 2007
            • 132

            #50
            Originally posted by Proaccesspro
            Scott,

            I sent the DB to you.......
            The "Has Multiple Appeal" button on the MAIN form contains the code in question

            Comment

            • Scott Price
              Recognized Expert Top Contributor
              • Jul 2007
              • 1384

              #51
              As I wrote back to you in my email, the problem was with the name of the Actions Subform. In the database window it is, indeed, 'Actions Subform', however on the Case Subform, it is treated as nothing more than 'Actions'. The corrected code is:

              [CODE=vb]
              Forms![MainForm]![Case Subform].SetFocus
              Forms![MainForm]![Case Subform].Form![Settlement Amount].SetFocus
              Forms![MainForm]![Case Subform].Form![Actions].Form![Action Date].SetFocus[/CODE]

              Good luck on the rest of your app!

              Regards,
              Scott

              Comment

              Working...