none
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

Answers

  • 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

    =[Child0]![SubTot]

    This works:


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

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

All replies