I have a subform called SubActionEmployees. Its footer has a textbox called txtActionEmp that is calculating and working properly. SubActionEmployees is on another subform called SubActions, and the default view for SubActions is single form. Its footer has a textbox called txtEmp that is pulling the data from txtActionEmp and its working properly UNTIL the next step&&..
SubActions is on another subform called SubWOTasks. When I open SubWOTasks, the footer for SubActions only shows the txtEmp value for the visible record, not for the total of all related records. For example, I view the two records in SubActions that are related to the visible record in SubWOTasks, and as I view each of SubActions two records, the SubActions footer shows the txtEmp value for that visible record only, where I need it to show the sum of txtEmp for both records. Control source for txtEmp is: =[SubActionEmployees]![txt
Thinking that I might need a DSum calculation in txtEmp, I tried about a million variations and never got past #Name?. If its a DSum that will do the job, can someone please give me the calculation? If not DSum, then why is this not working properly? Thanks so much! I've attached a picture.