Form and Subform Relationships ...

[Laney]

Hey there Guys and Gals,

Trying to get some help on a form and subform.

FORM
Employee ID which is a drop down menu to put the employee number in

and two text boxes with totals
one totals the regular hours
the next one totals the ot hours

and a close button to close the form one updates have been completed.

SUBFORM has the following fields and is set up like a spreadsheet inside the main form.
Employee ID which is also a drop down menu same as above
week ending
client
project
task
date
regular hours
ot hours
memo
completed

Right now I have it set up to where the employee can use the drop down emp # box to pull up their employee number and it will give them their hours for the week in the subform. It takes out everyone else's hours. This part works great!

What I need to do is...

In the main form the two text boxes that total up hours and ot hours calculate the totals for the columns. But they put the totals for all employees. How would I go about changing that to where when they use the drop down box and put their emp # in it will only total their hours?

And, how do you update the main form text boxes totals without closing and re-opening the entire form?

 

[Laney]

Thanks Pat!

Thank you ... I don't know why I didn't think of that myself. hehe Sometimes you know the answer you just need someone to remind you that you know it.

I put the total text boxes in the footer of the page and set it up to where you had to enter your emp # with the form and verify your emp # and subform ... now it pulls up each person's emp #, hours they've worked for that week, and gives the totals at the bottom.

Also did the same with my expense sheet.

Thankies!