How to retrieve Data from Multiple Items form when it is used as a subform

[channiekwon]

Hi,

I'm making a purchase order database.


Initially, what I did was that I created fields of up to 15 items in case the purchases may count up to 15,
but then felt that it was such a hassle because of the brute force, and that there are possibilities for purchases with more than 15 items and I would have to add new fields again,

So I ditched that solution and instead created a multiple items form and used it as a subform for my Purchase Order form, which is my main form.

THIS IS MY MULTIPLE ITEMS TABLE:



AND I USED IT AS A SUBFORM HERE:



Now my problem is....


I need to get the total amount from the items with the same Purchase order Number in my subform, so that it can appear in my SUBTOTAL field
which is a part of my main form
but I don't know how to get it.

Please help meeeee
Or if there is another way I can do a purchase order database that allows me to add any number of items I want without using a subform,

Please tell meeee

[ranman256]

On the sub form, in the footer, put the field to sum the col....
=sum([extTotal])

this can also be referenced from the master form.

[channiekwon]

Waah thanks for answering, but
May I know what the ext is for Cuz there's an error when I did it

[ranman256]

when you put the txtbox on the footer, you assigned it a field (well, a formula)
and it has the formula =Sum([myField])

is this where the error is? when you view the text box it shows #Name?
BUT
to reference it on the MASTER form, you must use the full path to the subform...use the BUILDER to do this
it will look like
=me!subform!form!txtSubTotal

use the builder to pick what you want. It always gets the spelling correct.

[channiekwon]

Oh! It works now!! Thank you so so much!!!