Update of fields and form

[yessir]

I have this form witha subform and i wish the subform as well as hte boxes to go to the proper data when any one is selected.

ie: if name selected, the date, ID, subform and the Total are all set to the proper records.

This is to allow ease of data entry.

also, The box at the bottom is a field in the REGISTER table, i want it to = the sum of the TotalsForSheet on the subform.

ANY HELP would be appreciated.

At the moment it updates the subform if a name, ID, or date is selected, but not anything else.

As well the dates are based on a year and will not show up Distinct.

 

[yessir]

CODE

CODE