Welcome to SPN

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

Sign Up Now!

subform lock

Discussion in 'Information Technology' started by Pam Coleman, Nov 8, 2005.

Tags:
  1. Pam Coleman

    Pam Coleman
    Expand Collapse
    Guest

    Is there a way to lock in a subform to the main form. My main form has
    information that is filled in when an emp # is entered. The subform is where
    entry is made based on the emp # so there may be many subforms attached to
    this number. Problem, when the form is opened it shows the last subform
    entry and there is no main form infor attached. I want the main and subform
    to be blank when the form is open and someone said you had to lock the
    subform. I am a novice to access and do not know how to write any code. I
    was wondering if there is a way to do this in the properties. Thanks,
     
  2. Loading...

    Similar Threads Forum Date
    Debate With Sarbjeet Singh Dhunda At Turlock (California) Gurdwara, April 2015 - YouTube Gurmat Vichaar Apr 23, 2016
    Uk clocks go back Blogs Oct 17, 2015
    Kesh: Dreadlocks Questions and Answers Nov 20, 2013
    Obamacare Faces Near-Solid Block In The South Health & Nutrition Mar 31, 2013
    Malaysia Have you forsaken your flock, Archbishop? Malaysia News Update Breaking News Jan 30, 2013

  3. tina

    tina
    Expand Collapse
    Guest

    what table is the main form bound to? what table is the subform bound to?
    how are the two tables related? and what are the names of the fields in the
    two tables that are linked?

    > The subform is where
    > entry is made based on the emp # so there may be many subforms attached to
    > this number.


    do you mean to say that there may be many *records* displayed in the single
    subform, for a single employee record in the main form? also, open the main
    form in design view and click on the subform control; in the Properties box,
    what are the values of the LinkChildFields and LinkMasterFields properties?


    "Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
    news:561780B2-0387-453F-BB2B-2224973D266B@microsoft.com...
    > Is there a way to lock in a subform to the main form. My main form has
    > information that is filled in when an emp # is entered. The subform is

    where
    > entry is made based on the emp # so there may be many subforms attached to
    > this number. Problem, when the form is opened it shows the last subform
    > entry and there is no main form infor attached. I want the main and

    subform
    > to be blank when the form is open and someone said you had to lock the
    > subform. I am a novice to access and do not know how to write any code.

    I
    > was wondering if there is a way to do this in the properties. Thanks,
     

Share This Page