Subform H*LL

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • DS
    #1

    Subform H*LL

    I have a form with 2 Subforms...The first subform is linked to the main
    form. The second Subform is liked to the first subform. Whenever I add
    a record to the first subform that works fine. When I add a record to
    the second subform that also works fine. The problem is the second
    subform always shows all of the records that are in it. Whenever I
    scroll through the records in the first subform, the records in the
    second subform should only show the records related to the first
    subform. The links seem to be working...I'm not getting an Error
    message. Am I doing something else wrong.
    Thanks
    DS
    Tags: None
    • DS
      #2
      Re: Subform H*LL Fixed...New Problem

      DS wrote:[color=blue]
      > I have a form with 2 Subforms...The first subform is linked to the main
      > form. The second Subform is liked to the first subform. Whenever I add
      > a record to the first subform that works fine. When I add a record to
      > the second subform that also works fine. The problem is the second
      > subform always shows all of the records that are in it. Whenever I
      > scroll through the records in the first subform, the records in the
      > second subform should only show the records related to the first
      > subform. The links seem to be working...I'm not getting an Error
      > message. Am I doing something else wrong.
      > Thanks
      > DS[/color]
      Ok I've got it to partillay work...it's now in sync, the only problem is
      that it's showing ALL of the records for that product, ot just for that
      particlar order, any suggestions? Thnaks
      DS

        Comment

        • Mal Reeve
          #3
          Re: Subform H*LL Fixed...New Problem

          On the properties sheet of the second sub form,
          check the LinkChild, LinkMaster properties...
          my guess is that is where the problem lies...
          or..
          easy solution...
          Make sure that the Design Wizard is turned on.
          then delete the second subform (just from the main form, not from the
          database) and then re-add it.
          HTH
          Mal.

          "DS" <bootybox@opton line.net> wrote in message
          news:Q6LQd.2305 5$_H5.22440@fe0 9.lga...[color=blue]
          > DS wrote:[color=green]
          >> I have a form with 2 Subforms...The first subform is linked to the main
          >> form. The second Subform is liked to the first subform. Whenever I add
          >> a record to the first subform that works fine. When I add a record to the
          >> second subform that also works fine. The problem is the second subform
          >> always shows all of the records that are in it. Whenever I scroll
          >> through the records in the first subform, the records in the second
          >> subform should only show the records related to the first subform. The
          >> links seem to be working...I'm not getting an Error message. Am I doing
          >> something else wrong.
          >> Thanks
          >> DS[/color]
          > Ok I've got it to partillay work...it's now in sync, the only problem is
          > that it's showing ALL of the records for that product, ot just for that
          > particlar order, any suggestions? Thnaks
          > DS[/color]


            Comment

            • DS
              #4
              Re: Subform H*LL Fixed...New Problem

              Mal Reeve wrote:[color=blue]
              > On the properties sheet of the second sub form,
              > check the LinkChild, LinkMaster properties...
              > my guess is that is where the problem lies...
              > or..
              > easy solution...
              > Make sure that the Design Wizard is turned on.
              > then delete the second subform (just from the main form, not from the
              > database) and then re-add it.
              > HTH
              > Mal.
              >
              > "DS" <bootybox@opton line.net> wrote in message
              > news:Q6LQd.2305 5$_H5.22440@fe0 9.lga...
              >[color=green]
              >>DS wrote:
              >>[color=darkred]
              >>>I have a form with 2 Subforms...The first subform is linked to the main
              >>>form. The second Subform is liked to the first subform. Whenever I add
              >>>a record to the first subform that works fine. When I add a record to the
              >>>second subform that also works fine. The problem is the second subform
              >>>always shows all of the records that are in it. Whenever I scroll
              >>>through the records in the first subform, the records in the second
              >>>subform should only show the records related to the first subform. The
              >>>links seem to be working...I'm not getting an Error message. Am I doing
              >>>something else wrong.
              >>>Thanks
              >>>DS[/color]
              >>
              >>Ok I've got it to partillay work...it's now in sync, the only problem is
              >>that it's showing ALL of the records for that product, ot just for that
              >>particlar order, any suggestions? Thnaks
              >>DS[/color]
              >
              >
              >[/color]
              I tried that. Didn't work. The Data changes as I go from one object to
              another. The Master/Child fields seem to connected correctly. Heres
              how my tables are set up.


              ORDER TABLE Order ID
              to
              ORDER DETAIL TABLE Order ID, Product ID
              to
              PRODUCTS TABLE Product ID
              to
              MOD DETAIL TABLE Product ID, Mod ID
              to
              MODS TABLE Mod ID

              Theres one more table here than the Northwinds Database has, I think
              that I need a code snippet on the after updates of the second form.
              Something that says choose only on current, but I don't have a clue how
              to write it?
              Thanks
              DS

                Comment

                • Tom van Stiphout
                  #5
                  Re: Subform H*LL

                  On Wed, 16 Feb 2005 10:52:02 -0500, DS <bootybox@opton line.net> wrote:

                  There is a standard solution for that. You have to "publish" the
                  primary key value of SF1 on the Parent form, and then use
                  LinkMasterField s of SF2 to point to that control.
                  I typically use a hidden textbox, and set the ControlSource to:
                  =SF1.Form!PK_Fi eld

                  -Tom.

                  [color=blue]
                  >I have a form with 2 Subforms...The first subform is linked to the main
                  >form. The second Subform is liked to the first subform. Whenever I add
                  >a record to the first subform that works fine. When I add a record to
                  >the second subform that also works fine. The problem is the second
                  >subform always shows all of the records that are in it. Whenever I
                  >scroll through the records in the first subform, the records in the
                  >second subform should only show the records related to the first
                  >subform. The links seem to be working...I'm not getting an Error
                  >message. Am I doing something else wrong.
                  >Thanks
                  >DS[/color]

                    Comment

                    • DS
                      #6
                      Re: Subform H*LL

                      Tom van Stiphout wrote:[color=blue]
                      > On Wed, 16 Feb 2005 10:52:02 -0500, DS <bootybox@opton line.net> wrote:
                      >
                      > There is a standard solution for that. You have to "publish" the
                      > primary key value of SF1 on the Parent form, and then use
                      > LinkMasterField s of SF2 to point to that control.
                      > I typically use a hidden textbox, and set the ControlSource to:
                      > =SF1.Form!PK_Fi eld
                      >
                      > -Tom.
                      >
                      >
                      >[color=green]
                      >>I have a form with 2 Subforms...The first subform is linked to the main
                      >>form. The second Subform is liked to the first subform. Whenever I add
                      >>a record to the first subform that works fine. When I add a record to
                      >>the second subform that also works fine. The problem is the second
                      >>subform always shows all of the records that are in it. Whenever I
                      >>scroll through the records in the first subform, the records in the
                      >>second subform should only show the records related to the first
                      >>subform. The links seem to be working...I'm not getting an Error
                      >>message. Am I doing something else wrong.
                      >>Thanks
                      >>DS[/color]
                      >
                      >[/color]
                      Thanks, I'll give it a try!
                      DS

                        Comment

                        Previous template Next
                        Working...