Welcome to SPN

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

Sign Up Now!

Display data from a linked table in a form.

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

  1. rg

    rg
    Expand Collapse
    Guest

    I want to display a read-only description field from a linked table in a form
    I am making. I know there must be an easy way to do this but I can't find it.
    I don't think I want a sub-form because this is just one field I want to
    display based on the linked value that the user will enter in this form.
    -rg
     
  2. Loading...

    Similar Threads Forum Date
    Heritage Sikh Artwork On Display At Texas University History of Sikhism Mar 6, 2015
    UK Sikh Turbans on display at Bradford exhibition Breaking News Mar 1, 2014
    History Rare photographs’ display: Sikh community and culture presented in vibrant colour Punjab, Punjabi, Punjabiyat Dec 8, 2013
    Events Manuscripts on display at National Museum of Pakistan. History of Sikhism Mar 3, 2013
    Turban Display Uncovers Sikh History Sikh Youth Jun 7, 2011

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    If your form is based on a query (it's not a good idea to base it on the
    table) then simply ensure the table (with the descriptive field) in on the
    query design area and double click the descriptive field. You can then bring
    it simply on to the form.

    Set the field to not enabled and take it out of the Tab Cycle (either way
    users will not be able to access the field just see it and its contents.

    There are many other ways of doing this but it best to always keep things
    simple if you can.

    Hope this helps

    --
    Wayne
    Manchester, England.



    "rg" wrote:

    > I want to display a read-only description field from a linked table in a form
    > I am making. I know there must be an easy way to do this but I can't find it.
    > I don't think I want a sub-form because this is just one field I want to
    > display based on the linked value that the user will enter in this form.
    > -rg
     
  4. rg

    rg
    Expand Collapse
    Guest

    Thank you, that was exactly what I was looking for. I was basing the form on
    the table, and when I changed it to a query it works so much better. :)
    -rg

    "Wayne-I-M" wrote:

    > If your form is based on a query (it's not a good idea to base it on the
    > table) then simply ensure the table (with the descriptive field) in on the
    > query design area and double click the descriptive field. You can then bring
    > it simply on to the form.
     

Share This Page