Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Please Help me!

Discussion in 'Information Technology' started by General Training, Jul 28, 2006.

Tags:
  1. General Training

    General Training
    Expand Collapse
    Guest

    I am having trouble figuring out how to have a subform complete itself once
    the first column is completed. The first column is selected using a table (A)
    that contains all the needed information. The subform has blank columns
    labeled the same as table (A). I hear I need to use a query of some form to
    do this...
     
  2. Loading...

    Similar Threads Forum Date
    General Help! Looking for a good clairvoyant/card reader......any suggestions? Please Blogs Jan 25, 2016
    Please help Questions and Answers Nov 1, 2013
    Please Help! What is the Name of the Narrator/Raagi? Gurbani Download Oct 16, 2012
    Muslim Girl-Sikh Boy Marriage Problems- Please Help! Love & Marriage Oct 12, 2012
    Help Please :/ Relationships Apr 19, 2011

  3. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    Hello "General Training".

    "General Training" wrote:
    > I am having trouble figuring out how to have a subform complete itself
    > once the first column is completed. The first column is selected using
    > a table (A) that contains all the needed information. The subform has
    > blank columns labeled the same as table (A). I hear I need to use a
    > query of some form to do this...


    This should be a "lookup query".
    There will be only one value entered in the subform, so I guess the
    table (tableB?) the subform is based on contains only this field and a
    field that allows linking the subform with the master form.
    Create a query that contains both tableB and tableA. The fields in the
    query should be all fields of tableB and the fields of tableA you want to
    be displayed in the subform. The fields to be linked in this query are:
    The field from tableB that stores the selected value in the subform
    and the field from tableA that the selectable value comes from.
    To prevent users from modifying the values automatically filled (these
    come from tableA and they are displayed for all records from tableB
    where the same value was selected), lock the corresponding controls.

    --
    Regards,
    Wolfgang
     
  4. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    Hello "General Training".

    "General Training" wrote:
    > I am having trouble figuring out how to have a subform complete itself
    > once the first column is completed. The first column is selected using
    > a table (A) that contains all the needed information. The subform has
    > blank columns labeled the same as table (A). I hear I need to use a
    > query of some form to do this...


    The subform should be based on a "lookup query" (sorry, I forgot to
    mention that in my previous post).
    There will be only one value entered in the subform, so I guess the
    table (tableB?) the subform is based on contains only this field and a
    field that allows linking the subform with the master form.
    Create a query that contains both tableB and tableA. The fields in the
    query should be all fields of tableB and the fields of tableA you want to
    be displayed in the subform. The fields to be linked in this query are:
    The field from tableB that stores the selected value in the subform
    and the field from tableA that the selectable value comes from.
    To prevent users from modifying the values automatically filled (these
    come from tableA and they are displayed for all records from tableB
    where the same value was selected), lock the corresponding controls.

    --
    Regards,
    Wolfgang
     

Share This Page