Subform help! Child/Master fields keep repopulating!

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

    Subform help! Child/Master fields keep repopulating!

    Hi,

    I have a 2 subform form, which uses the selection of a row in subform
    1 to show a set of rows in subform 2.

    I have my queries pointing directly to fields on my form to choose
    what data is shown.

    However, when I first populated this form with my subforms, I was dumb
    (apparently) and had it accidentally pick "List_ID" as my child/master
    field for subform 2.

    Now, when I wipe out List_ID as my child/master field. The form works
    perfectly when it first opens.

    But, the second I choose/change anything on my form. Presto/chango,
    my nemesis - List_ID is back in the spot limiting my data in Subform
    2. Blargh.

    WTF! I'm on Access 2003. And I'm going to try to add the subform to
    the form without setting any child/masterfields.

    But, does anyone know what I'm doing wrong? I've cleared "List_ID" in
    both the properties window and the little ... popup.

    TIA,

    Jon
    Tags: None
    • jonceramic
      #2
      Re: Subform help! Child/Master fields keep repopulating!

      On Oct 14, 11:17 pm, jonceramic <joncera...@gma il.comwrote:
      Hi,
      >
      I have a 2 subform form, which uses the selection of a row in subform
      1 to show a set of rows in subform 2.
      >
      I have my queries pointing directly to fields on my form to choose
      what data is shown.
      >
      However, when I first populated this form with my subforms, I was dumb
      (apparently) and had it accidentally pick "List_ID" as my child/master
      field for subform 2.
      >
      Now, when I wipe out List_ID as my child/master field.  The form works
      perfectly when it first opens.
      >
      But, the second I choose/change anything on my form.  Presto/chango,
      my nemesis - List_ID is back in the spot limiting my data in Subform
      2.  Blargh.
      >
      WTF!  I'm on Access 2003.  And I'm going to try to add the subform to
      the form without setting any child/masterfields.
      >
      But, does anyone know what I'm doing wrong?  I've cleared "List_ID" in
      both the properties window and the little ... popup.
      >
      TIA,
      >
      Jon
      Update:
      Recreating the field didn't help.

      Since I'm using the same form table as I'm using the in the query for
      subform 2, I decided that it was probably some name autocorrect thing
      going on. (I have a join so that everything from my "seed" contacts
      table is show, and on my "chosen" contacts table, only those with
      matching "List_ID"'s are joined.)

      So, I changed the List_ID to be named "FakeList_I D" via a query
      expression, and now everything shows up. As planned. Without it
      reinserting List_ID/List_ID as my master/Child relationship. But, I
      wish I didn't have to do this.

      Still looking for a clue for a better fix.

      Thanks,

      Jon

        Comment

        • Salad
          #3
          Re: Subform help! Child/Master fields keep repopulating!

          jonceramic wrote:
          Hi,
          >
          I have a 2 subform form, which uses the selection of a row in subform
          1 to show a set of rows in subform 2.
          >
          I have my queries pointing directly to fields on my form to choose
          what data is shown.
          >
          However, when I first populated this form with my subforms, I was dumb
          (apparently) and had it accidentally pick "List_ID" as my child/master
          field for subform 2.
          >
          Now, when I wipe out List_ID as my child/master field. The form works
          perfectly when it first opens.
          >
          But, the second I choose/change anything on my form. Presto/chango,
          my nemesis - List_ID is back in the spot limiting my data in Subform
          2. Blargh.
          >
          WTF! I'm on Access 2003. And I'm going to try to add the subform to
          the form without setting any child/masterfields.
          >
          But, does anyone know what I'm doing wrong? I've cleared "List_ID" in
          both the properties window and the little ... popup.
          >
          TIA,
          >
          Jon
          You probably needed to set the Listbox to the new value first. Ex:
          Forms!MainForm! ListBox = Me.IDValue 'change to your names
          Forms!MainForm! SF2.Form.Requer y

          You could set the filter manually as well
          Forms!MainForm! SF2.Form.Filter = Me.IDValue
          Forms!MainForm! SF2.Form.Filter On = True


            Comment

            • rquintal@sympatico.ca
              #4
              Re: Subform help! Child/Master fields keep repopulating!

              On Oct 15, 12:33 am, jonceramic <joncera...@gma il.comwrote:
              On Oct 14, 11:17 pm, jonceramic <joncera...@gma il.comwrote:
              >
              >
              >
              >
              >
              Hi,
              >
              I have a 2 subform form, which uses the selection of a row in subform
              1 to show a set of rows in subform 2.
              >
              I have my queries pointing directly to fields on my form to choose
              what data is shown.
              >
              However, when I first populated this form with my subforms, I was dumb
              (apparently) and had it accidentally pick "List_ID" as my child/master
              field for subform 2.
              >
              Now, when I wipe out List_ID as my child/master field.  The form works
              perfectly when it first opens.
              >
              But, the second I choose/change anything on my form.  Presto/chango,
              my nemesis - List_ID is back in the spot limiting my data in Subform
              2.  Blargh.
              >
              WTF!  I'm on Access 2003.  And I'm going to try to add the subform to
              the form without setting any child/masterfields.
              >
              But, does anyone know what I'm doing wrong?  I've cleared "List_ID" in
              both the properties window and the little ... popup.
              >
              TIA,
              >
              Jon
              >
              Update:
              Recreating the field didn't help.
              >
              Since I'm using the same form table as I'm using the in the query for
              subform 2, I decided that it was probably some name autocorrect thing
              going on.  (I have a join so that everything from my "seed" contacts
              table is show, and on my "chosen" contacts table, only those with
              matching "List_ID"'s are joined.)
              >
              So, I changed the List_ID to be named "FakeList_I D" via a query
              expression, and now everything shows up.  As planned.  Without it
              reinserting List_ID/List_ID as my master/Child relationship.  But, I
              wish I didn't have to do this.
              >
              Still looking for a clue for a better fix.
              >
              Thanks,
              >
              Jon- Hide quoted text -
              >
              - Show quoted text -
              Turn off the Name Autocorrupt thing, from the menu bar->Tools->Options-
              >Gweneral(Tab )->Name Autocorrect->Track Name Autocorrect Info.
              Q

                Comment

                Previous template Next
                Working...