Welcome to SPN

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

Sign Up Now!

Display Information From Another Form In a Control

Discussion in 'Information Technology' started by ksenya.lim@gmail.com, Jul 28, 2006.

  1. ksenya.lim@gmail.com

    ksenya.lim@gmail.com
    Expand Collapse
    Guest

    Hey,

    My problem is that I want a few controls on my form display
    corresponding record from controls placed on another form (forms are
    based on 2 tables, one-to-many relationship, control source
    =[Forms]![FormName]![ControlName]). It worked before when the 2 forms
    were open at the same time. Now when one form closes and another opens
    all i get is #Name. Is there any way to solve this problem? Thanks a
    lot!
     
  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. Nikos Yannacopoulos

    Nikos Yannacopoulos
    Expand Collapse
    Guest

    Of course you wouldn't be able to read from a closed form! The form does
    not hold data itself, it merely hosts data while it is open. What you
    should do is read the data directly from the table it is stored in. Most
    likely, all you need is a DLookup function (look it up in Access help).

    HTH,
    Nikos
     
  4. ksenya.lim@gmail.com

    ksenya.lim@gmail.com
    Expand Collapse
    Guest

    Thanks a lot! I used the DLookup function and it worked perfectly!
    Nikos Yannacopoulos wrote:
    > Of course you wouldn't be able to read from a closed form! The form does
    > not hold data itself, it merely hosts data while it is open. What you
    > should do is read the data directly from the table it is stored in. Most
    > likely, all you need is a DLookup function (look it up in Access help).
    >
    > HTH,
    > Nikos
     

Share This Page