RE: pass a calculated form field to a subform field?

Thank you very much...

That worked... I was unaware of the "Parent" as a reserved word.

I do have another question... I'm not sure if you can answer or not..

The setup that was just created is for my invoicepayments subform, which
takes the invoice total and then allows the user to enter payments that are
deducted from the total.

What I am trying to do is this:

Payment1 is deducted from the invoice total giving a Balance Due, then each
additional payment is then deducted from the Balance Due to calculate a new
account balance..

Do you understand... do you know how I can accomplish this?

Thanks,

Brook

"Sprinks" wrote:

> Hi, Brook.
>
> No, I meant it literally--"Parent" is a reserved Access word. Cut and paste
> the following into the Control Source property of the subform control:
>
> =[Parent].[Form]![invoicetotal]
>
> Hope that helps.
> Sprinks
>
> "Brook" wrote:
>
> > hello Sprinks,
> >
> > Thanks for the tip,
> >
> > I am assuming that you mean make the value of my invoicetotal on my
> > subform to be: =frminvoices.Form!invoicetotal
> >
> >
> > When I do this, I get: #Name?
> >
> > my "main form/parent form" is called frminvoices, and my field is called
> > invoicetotal
> >
> > the invoicetotal is based on another subform within the same parent form
> > =[invoicesubtotal]+[ShippingCost]
> >
> > so I have two subforms and a main form.
> >
> > and I don't know if this matters, but my subforms are located on two tabs.
> > one for product enty and one for payment enter.
> >
> > Thanks for the response..
> >
> > Brook
> >
> >
> > Any Ideas?
> >
> >
> >
> > "Sprinks" wrote:
> >
> > > Hi, Brook. Try:
> > >
> > > =[Parent].[Form]![invoicetotal]
> > >
> > >
> > > Hope that helps.
> > > Sprinks
> > >
> > > "Brook" wrote:
> > >
> > > > hello all..
> > > >
> > > > I am trying to pass a calculated form (frminvoices) field (invoicetotal
> > > > (This is a calculated field)) to subform (frminvoicepayments subform) field
> > > > (invoicetotal).
> > > >
> > > > I know this should be easy, but I have racked my brain on this one...
> > > >
> > > > Can anyone help?
> > > >
> > > > Thanks,
> > > >
> > > > Brook
.

Relevant Pages

  • Re: Asking too much?? Form-subform based on 4 tables, one is a junction table.
    ... the subform be based on query on the-other one-table. ... One receipt from a customer can be used to pay more than one invoice. ... Then the user will enter the payment amount for each invoice, ...
    (microsoft.public.access.formscoding)
  • Asking too much?? Form-subform based on 4 tables, one is a junction table.
    ... the subform be based on query on the-other one-table. ... One receipt from a customer can be used to pay more than one invoice. ... Then the user will enter the payment amount for each invoice, ...
    (microsoft.public.access.formscoding)
  • RE: pass a calculated form field to a subform field?
    ... when I pull up my invoicepayment subform, ... "Sprinks" wrote: ... display the balance due as of a given payment: ... The only field you need in tblInvoicePayments to relate it to ...
    (microsoft.public.access.forms)
  • Re: Table Design Help / Query
    ... Use this query as the source for your subform. ... That shows the invoice total. ... One payment that covers multiple invoices; ... So the simplest solution is just to sum all the invoices for a client, subtract the payments received, and the difference is what is owing. ...
    (microsoft.public.access.tablesdbdesign)
  • help with a subform calculation...
    ... with two subforms frminvoicedetails subform & ... I use to enter new orders for my invoice, ... invoicesubtotal calculated field and a shippingtotal calculated field ... I would like for the first payment to be deducted from the invoicetotal, ...
    (microsoft.public.access.formscoding)