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: https://599cd.com/ValueFromSubform PRE-REQUISITES: Invoicing: https://599cd.com/Invoicing Value From a Form: https://599cd.com/FormName RECOMMENDED COURSES: Access Expert 2: https://599cd.com/AC10X2 Access Developer 7: https://599cd.com/ACD7 LINKS: DSum: https://599cd.com/DSum NZ Function: https://599cd.com/NZ After Update: https://599cd.com/AfterUpdate SYNTAX Fields on a single form: Forms!FormName!FieldName Fields on a subform: Forms!ParentFormName!SubFormName.Form!FieldName BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... 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.