Calling Data from a text box in a subform RRS feed

  • Question

  • Ive watched countless videos on this... wanted to get yalls opinion on the matter.

    I have a sub form "SUB" with qty, price, and extended price (=[Qty]*[Price]) in data sheet view (applicable table as RS). In the footer I have a custom txt box =sum([Qty]*[Price]) OR OR =sum([Extended Price]). Lets call this custom box SubTot.

    In the main form I have a custom txt box (equation from navigating through expression builders network paths) =[Forms]![Sub]![SubTot]

    The result of the main forms txt box is #Name?

    Would anyone know why access is not liking me at the moment?

    Thursday, July 12, 2018 6:29 PM


  • As you can see in the screenshot, the Name of the subform on the main form is Child0 (Sub is the name of its source object).

    So you should use


    This works:

    Regards, Hans Vogelaar (

    • Marked as answer by jshot Thursday, July 12, 2018 10:11 PM
    Thursday, July 12, 2018 10:07 PM

All replies