none
Calculated field showing #Error RRS feed

  • Question

  • Hello,

    I have a field that I used to calculate a time duration to the nearest half hour.  The calculation works fine, but the calculation is done on a subform, and I have to refer to the calculated field from the main form, I which I do by setting the control source of a text field to the calculated field on the subform.  My problem is that I keep getting that #Error on the field on the main form.

    So I set the control source of the text box on the main form as follows -=[Activities].[Form]![txtSum2]


    olu Solaru

    Tuesday, July 30, 2019 3:18 PM

All replies

  • What is the name of your sub form? Is it the same as the name of the sub form control?

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, July 30, 2019 6:00 PM
  • the syntax for calling a control on the main form (from a control on the subform) is:

    =Parent.ControlName

    Wednesday, July 31, 2019 12:57 PM
  • To get the value of a control on a subform to show on the main form, you do it like this:

    ControlSource in properties box

    =[subform control name]![control name]

    For example, if the subform control is named Customers1 and the text box on the subform is named Company

    =[Customers1]![Company]


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, July 31, 2019 6:30 PM