Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

get 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 have a mainform [Invoicefrm) and subform [InvoiveDetailsform]

    Invoicefrm has field "Invoice#" and "InvoiceDate"
    I want to set the Invoice # of the mainform to each line item of the subform.

    The Link master and child fields has already been used for another
    operation. is there anyway this can be done. I referenced the "Invoice#"
    field on the subform to that of the mainform and it works but the data is not
    passed to the underlying query.

    please help
     
  2. Loading...


  3. Pat Hartman\(MVP\)

    Pat Hartman\(MVP\)
    Expand Collapse
    Guest

    The records in the subform only need the primary key of the Invoice and that
    should be populated automatically by the master/child links. If InvoiceNum
    (# is a poor choice in a column name) is the primary key then fix the
    master/child links.

    "Levans digital" <Levansdigital@discussions.microsoft.com> wrote in message
    news:109F7A8C-1B44-4AB9-85FB-EFB92E9C4192@microsoft.com...
    >I have a mainform [Invoicefrm) and subform [InvoiveDetailsform]
    >
    > Invoicefrm has field "Invoice#" and "InvoiceDate"
    > I want to set the Invoice # of the mainform to each line item of the
    > subform.
    >
    > The Link master and child fields has already been used for another
    > operation. is there anyway this can be done. I referenced the "Invoice#"
    > field on the subform to that of the mainform and it works but the data is
    > not
    > passed to the underlying query.
    >
    > please help
    >
     
  4. Levans digital

    Levans digital
    Expand Collapse
    Guest

    Hey Thanks very much I see where you are coming from.
    After using ur suggestions. I was able to solve the situation

    "Pat Hartman(MVP)" wrote:

    > The records in the subform only need the primary key of the Invoice and that
    > should be populated automatically by the master/child links. If InvoiceNum
    > (# is a poor choice in a column name) is the primary key then fix the
    > master/child links.
    >
    > "Levans digital" <Levansdigital@discussions.microsoft.com> wrote in message
    > news:109F7A8C-1B44-4AB9-85FB-EFB92E9C4192@microsoft.com...
    > >I have a mainform [Invoicefrm) and subform [InvoiveDetailsform]
    > >
    > > Invoicefrm has field "Invoice#" and "InvoiceDate"
    > > I want to set the Invoice # of the mainform to each line item of the
    > > subform.
    > >
    > > The Link master and child fields has already been used for another
    > > operation. is there anyway this can be done. I referenced the "Invoice#"
    > > field on the subform to that of the mainform and it works but the data is
    > > not
    > > passed to the underlying query.
    > >
    > > please help
    > >

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page