Welcome to SPN

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

Sign Up Now!

data from main form to subform

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

  1. Levans digital

    Levans digital
    Expand Collapse
    Guest

    I populate my subform by entering matching data into the main form. This is
    done by using the Master and Child fiels properties of the subform. Good!

    However I also want to past different data from the main form to the subform
    and after reading the posts they all suggest doing the same Master and Child
    Field properties please help.

    I found out that both cannot be done on the same form.

    Please help
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 15 Jun 2006 15:41:03 -0700, Levans digital
    <Levansdigital@discussions.microsoft.com> wrote:

    >I populate my subform by entering matching data into the main form. This is
    >done by using the Master and Child fiels properties of the subform. Good!
    >
    >However I also want to past different data from the main form to the subform
    >and after reading the posts they all suggest doing the same Master and Child
    >Field properties please help.


    Why?

    Storing data redundantly is almost NEVER a good idea.

    You can do it, programmatically in VBA, but before I post code I'd
    like to be sure I wouldn't be giving you the tools to do something
    you'll regret doing!

    John W. Vinson[MVP]
     

Share This Page