Hi,
Eventhogh i know calculated control are for queries, i still need to store a calculated value of a sum. I have a form with customers, dates, locations. That form has a subform that contains the services done and materilas used. This subform is in datasheet view. In the footer i have a control with =Sum([Price]). So i need the value of this control to be stored in the table the main form is based on. I did an unbound control in the main form where the =Me!Subform.Form!.Textx will bring the value "over" Then for the on focus event the vba code Me.Total=Me.Textx stores the value. That is fine. The same works with a command button with the same vba code. However i am asking if there is a more automatic way to get the value over without the unbound control/command button.
thanks
Andy
Eventhogh i know calculated control are for queries, i still need to store a calculated value of a sum. I have a form with customers, dates, locations. That form has a subform that contains the services done and materilas used. This subform is in datasheet view. In the footer i have a control with =Sum([Price]). So i need the value of this control to be stored in the table the main form is based on. I did an unbound control in the main form where the =Me!Subform.Form!.Textx will bring the value "over" Then for the on focus event the vba code Me.Total=Me.Textx stores the value. That is fine. The same works with a command button with the same vba code. However i am asking if there is a more automatic way to get the value over without the unbound control/command button.
thanks
Andy