B
Bob Love
I've asked this question before but have some how messed it up again. I have
a main form and subform. In the sub form footer I have a control named
Subtotal with the control source property = Sum([Extended Price). Extended
price is a calculated control on the subform. The subform is based upon a
table and not a query. I want to use the control in the footer of the
subform to fill in the "Subtotal" control on the main form. In the control
source property for the "Subtotal" control on the main form I have =[Order
Detail Subform]![Subtotal] but I get an error. This is in access 2007 BTW.
a main form and subform. In the sub form footer I have a control named
Subtotal with the control source property = Sum([Extended Price). Extended
price is a calculated control on the subform. The subform is based upon a
table and not a query. I want to use the control in the footer of the
subform to fill in the "Subtotal" control on the main form. In the control
source property for the "Subtotal" control on the main form I have =[Order
Detail Subform]![Subtotal] but I get an error. This is in access 2007 BTW.