Welcome to SPN

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

Sign Up Now!

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
    > >

    >
    >
    >
     

Share This Page