Doesn't add up

[bigfoot53]

Hello all,
well i just cant seem to figure this out in the enclosed DB you will see that i an creating a employee work hours DB the main form works well . the problem is the sub form the Employee id auto fills but i just cant get the regular and overtime times to fill in . i would really like to be able to filter the totals by the current work week "sunday through saturday" and have the currents weeks totals dispayed in the form if that can even be done.


thanks for any help

 

[glynch]

I don't have Access on the PC I am working with right now so I can't look at your mdb but a common problem with form/subform is improper choices of the master field/child field relationship in the properties of the subform. Perhaps that is where the problem lies. I have seen people try to contradict the table relationships in their mdb with the formsubform arrangements they try to create.

THis might not even be your problem but it is worth checking out.

HTH