B
BZeyger
I have a form that does numerious things. There are many text boxes that
contain values. What I am tring to do is store a value from a text box that
calculates a total, then tie that total into a record.
There is a form the has many lines in the detail section:
Project/Writer Hours/ Art Hours
The footer section has the totals of the details:
Total Writer Hours/ Total Art Hours/ Total All
The textbox for the sum contains "=Sum([Writer hours])" in Control Source
section
The textbox for the sum contains "=Sum([Art hours])" in Control Source section
The textbox for the total contains "=((Sum([Writer hours]))+(Sum([Art
hours])))" in Control Source section.
I would like the textbox for the total to be stored in a specific field in
the Projects table named "Total Hours".
How would I do this?
contain values. What I am tring to do is store a value from a text box that
calculates a total, then tie that total into a record.
There is a form the has many lines in the detail section:
Project/Writer Hours/ Art Hours
The footer section has the totals of the details:
Total Writer Hours/ Total Art Hours/ Total All
The textbox for the sum contains "=Sum([Writer hours])" in Control Source
section
The textbox for the sum contains "=Sum([Art hours])" in Control Source section
The textbox for the total contains "=((Sum([Writer hours]))+(Sum([Art
hours])))" in Control Source section.
I would like the textbox for the total to be stored in a specific field in
the Projects table named "Total Hours".
How would I do this?