Sum lost day type by active employee

[tuxalot]

I've attached a screenshot to help explain what I need. If it is difficult to see the details, a larger file is located here:

http://depositfiles.co m/files/s94abwbk2

The Date History form (shown with a green #1) is where the user enters data. The summary data is visible in Date History subform (green #2). These data are stored in the Date History table shown at the bottom.

I would like Lost time days and Restricted work days to automatically total (shown with the red numbers 5 & 10).

This group is most helpful. Thanks for looking at this post.

[ChipR]

I can't quite make out the picture, but I think what you want to do is put code in the OnCurrent event of the main form. Set each textbox using the DSum function.