Two Access questions!

[archcommus]

I have a form that performs a select query and then a subform within it. The subform displays the currently selected record from the main form by linking common child/master fields, and then lets you enter new data records for each main form record, and this whole subform is linked to a table that all the data gets written to. Both forms are set to "continuous forms."

I need the following two things:

DONE 1) A field in the subform that sums a particular field from the records on the subform. In other words, if each record in the subform has "members" and "hours," I need "total hours" at the top of the subform across all members.

2) A field in the subform that lets you enter a total for that entire record from the main form. In other words, it won't be wiped out when you make a new subform record like member, hours, etc. will be.

Thanks for any assistance.

 

[archcommus]

1) was easy, done.

2) still stands. To rephrase, I have records in a main form, and details about each record in a subform. The subform itself has multiple records in continuous form view. However one property of each record from my main form must be the SAME for all records in the subform. In other words it needs to not be cleared out when making a new record in the subform.