Re: [MS_AccessPros] Re: Invoice totals

 

Adam-

Yes, that could also work.  Use =Forms![<name of outer form>]![<name of subform control>].Form!InvTotal

That control would need to be repainted after every change in the subform.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 6, 2015, at 11:04 PM, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

I'm curious. Instead of a dsum, could, or would you want to, have txtTotal refer to a field on a subform? Something like: =forms.frmInvoiceDetail!InvTotal

Where InvTotal = Sum(("[Qty] * [Price])

I thought you generally tried to avoid domain aggregate functions.

Adam

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___