Unbound TextBox Calculation Question

[PhilG]

Okay, I am using this syntax as the control source for an unbound textbox which is supposed to display the calculated unbound textbox in the footer of a sub-form:



=Sum([ACTimeInitial]+[txtHourSum])

and

=Sum([ACCyclesInitial]+[txtCycleSum])

txtCycleSum and txtHourSum are the names of the unbound textboxes in the footer of the sub-form which calculates incremental values that have been added to an Action_Log. Control source syntax of those textboxes are:

=Sum([FlightHours]) and =Sum([FlightCycles]) , respectively.

The idea is then what is posted above. Basically, adding the calculated field to an initial aircraft value and having that displayed in the main form.

txtCycleSum and txtHourSum are created in a sub-form footer , if that makes any difference

I am not sure where I am going wrong!

Thanks for any help coming my way!

 

[Galaxiom]

The Sum can only be applied to fields in the Recordset. It cannot address controls.

 

[PhilG]

Well, turns out I needed to add 'Parent.' to the calculation controls.. now the aggreg function can work within a form/sub-form setup