Welcome to SPN

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

Sign Up Now!

Sub forms - need help fast

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

Tags:
  1. tiff2703

    tiff2703
    Expand Collapse
    Guest

    Hi,

    i have a main form which has tabs relating to different tasks for customers
    ie. tab one is contacts, tab two is farm description, tab three is a
    declaration form. in the declaration tab i need to have a sub-form (i think)
    which allows data entry but also holds details from tab two.

    ie the farm description fields will show up so that i know what data to
    enter to the correct farm
     
  2. Loading...

    Similar Threads Forum Date
    Movies Want movie Subeg Singh Shahbaz Singh Theatre, Movies & Cinema Jan 12, 2016
    United Sikhs Sikh woman sues suburban go-kart park after hair cut from motor Sikh Organisations Jan 9, 2014
    World Milkha Singh-inspired character makes appearance on Subway Surfers Breaking News Jan 7, 2014
    The Inner Experience and the Subconscious Mind Interfaith Dialogues Dec 6, 2013
    Opinion 1984 Sikh Genocide Petition To Be Submitted To The UN Breaking News Oct 23, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    If you have a text box named Text0 on another tab, you can show the same
    thing on this tab by adding a text box and setting its Control Source
    property to:
    =[Text0]

    If you want something that is visible in all tabs, add the text box to the
    form, outside the tab control. Then move it on top of the tab control, and
    it will show through all pages.

    Another alternative is use the Title bar of the form to show a crucial piece
    of information. Use code in the Current event of the form to set the Caption
    of the form.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "tiff2703" <tiff2703@discussions.microsoft.com> wrote in message
    news:82127254-1282-43F2-98EC-12A80BA1BBC6@microsoft.com...
    >
    > i have a main form which has tabs relating to different tasks for
    > customers
    > ie. tab one is contacts, tab two is farm description, tab three is a
    > declaration form. in the declaration tab i need to have a sub-form (i
    > think)
    > which allows data entry but also holds details from tab two.
    >
    > ie the farm description fields will show up so that i know what data to
    > enter to the correct farm
     

Share This Page