How to retrieve data from a subform and display it in the main form?

[zolazree]

So basically, I'm trying to retrieve the SUM of the data (refer image below) from the field "TotalPrice" (highlighted red) in the subform and put it into the "Sales" (highlighted blue) field in the main form. I've tried a few things including using the DLOOKUP function, but then the "Sales" field but that didn't work as I wanted it to. I'm really quite new to MS Access and I hope someone can help me with this for my school assignment. Thanks!

[RuralGuy]

The easiest way is to let the SubForm do its own total in the footer of the SubForm and then let your main form control get it using this syntax: http://access.mvps.org/access/forms/frm0031.htm

[zolazree]

I dont know how to delete this

[zolazree]

The easiest way is to let the SubForm do its own total in the footer of the SubForm and then let your main form control get it using this syntax: http://access.mvps.org/access/forms/frm0031.htm

Hi RuralGuy,
I'm having trouble understanding which syntax that I'm supposed to use and how do I type it in the design of my forms.
Would you kindly help me out by showing me exactly how to do it?
Thanks !

[RuralGuy]

The control source of the control in the Main Form would look like:
= SubFormControlName.FORM.SubFormName.ControlName

In the link I provided it is described as:
Me!Subform1.Form!ControlName
...where in fact there are several forms of the syntax that work.

[zolazree]

The control source of the control in the Main Form would look like:
= SubFormControlName.FORM.SubFormName.ControlName

In the link I provided it is described as:
Me!Subform1.Form!ControlName
...where in fact there are several forms of the syntax that work.

I'm sorry RuralGuy, but I just can't seem to make it work .
Errors keep happening, & I don't know what I did wrong...
Do I just type in the syntax u gave above into the Unbound field (blue) if I want the SUM of the TotalPrice field from the subform (red)?

Maybe you could tell me more about what the "Me!" function does or is it even a 'function', or what does the "SubForm1.Form" or the "ControlName" represents. Do I change it to something in my database? Is the 'SubForm1' supposed to be the name of the subform, and is the 'ControlName' the name of the field in the subform that I want to retrieve (for my case, the 'TotalPrice' field?).

I'm sorry man, I've no clue what I'm supposed to do.

[RuralGuy]

What is the name of your SubFormControl? Not the SubForm that it displays but the name of the control that displays it?
What is the name of the control on your SubForm that displays the TotalPrice?

[zolazree]

What is the name of your SubFormControl? Not the SubForm that it displays but the name of the control that displays it?
What is the name of the control on your SubForm that displays the TotalPrice?

Its name on the SubForm is 'TotalPrice'

[RuralGuy]

If you want the correct syntax you will need to answer all of the questions I asked.
I will take a guess and say:
= Me!TotalPrice.Form!TotalPrice
...again, you need the CorrectNames in these two positions.

[zolazree]

If you want the correct syntax you will need to answer all of the questions I asked.
I will take a guess and say:
= Me!TotalPrice.Form!TotalPrice
...again, you need the CorrectNames in these two positions.

Hey, RuralGuy. Thanks a lot man. I finally figured it out. The expression I used was, =[tSalesSubform1].[Form]![InvoiceTotal].
I'm starting to get the hang of all this now. Sorry if I didn't understand some of what u said earlier on. Thanks again!

[RuralGuy]

Excellent! Glad you figured it out.

I marked this thread as *Solved* for you, using the *Thread Tools* at the top of the thread.
https://www.accessforums.net/showthread.php?t=1828