How to Get a Value from a Subform in Microsoft Access

In this Microsoft Access tutorial, I'm going to show you how to sum up a field in a subform and display that on the parent form, instead of using the subform footer.

Andrew from Rochester, New York (a Gold Member) asks: Is there a way that I can sum up a value based on a field in a subform and display that on the parent form, instead of using the subform footer?

LEARN MORE:

PRE-REQUISITES:

RECOMMENDED COURSES:

LINKS:

SYNTAX
Fields on a single form: Forms!FormName!FieldName
Fields on a subform: Forms!ParentFormName!SubFormName.Form!FieldName

BECOME A MEMBER:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #Error, How to get a subform field value, How to Retrieve Values on a Subform, Pass value between a subform and a main form, parent, How to get a value from subform, value from parent form

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[Richard.E]

Hi Richard, your videos are by far the best I have watched on Access, I've gone from complete clueless beginner to building my first access database purely on your lessons.

[rogerstrate]

Thanks so much Richard, I have had this question on my mind for several weeks and you nailed it perfectly for me in this video. I certainly appreciate you and all I continue to learn with Access you are my hero.

[khia]

Are you spying on me? I feel like you’re spying on me! Every time I run into a problem you come out with a video that’s the exact answer to what I need! Loving your content ^^ thank you so much for all you do!

[albyluchko]

hi Richard - thank you for all the video tutorials! My question is this: I created a continuous form with search boxes as you explained in another video. Works GREAT! I was trying to insert that form (ResearchersListF) as a subform into another form but it doesn't connect the search fields in the query (which references the textboxes in the form e.g. I get pop ups asking for the values for the search fields whenever it runs the query. the query can't find what it needs. Am I not allowed to use a form also as a subform? I preferred embedding the list of researchers and its search functions into this other form rather than popping open another form/window, but I certainly could if I had to. I hope that makes sense. Basically, can I create a form the relies on a query (as its own form) and also use it as an embedded subform in a different form?

[mosjany]

Thanks for this class its great....but I have one headache > how to I collect invoice payments, able to see invoice balances if paid partial etc please if you can assist

[compa]

Great Content as always. QUESTION: How can I go about showing outside the subform a DetailSummary where I see All Product Quantity + Name? I tried DetailSummary=[Quantity] & " " & [Name] & " + " in subform footer. And then referenced from parent form with The footer field comes out perfectly to from the subform to form. But I cant get the Subform footer to concatenate the Name and Quantity further than the first field from the datasheet subform. Can you think of any way to iterate through the subform datasheet entries whilst concatenating? THANKS!

[paulojorgecasanova]

I liked this code to fetch values from the sub-form to the parent form:

Dim valor As String


'Get the value of the "Nº série" field in the subform
valor =


' Assign the value to the "SN" field in the parent form
Me.SN.Value = valor

[robertodc]

in the parent form or in eny other open form