Subform Addition #Error

[karassik]

I am running Access 2000. The problem form is for tracking Hours. I have a main form that hold employees names and a continuous subform is fed off of those names. The subform holds the date and hours and operation, so one day could have multiple entries. I have some a Text box on the bottom of the form for total hours from the most recent day and then total hours from the most recent week. For the most recent weeks hours I have 7 text boxes. Mon,Tues,etc. with : =Nz(DSum("[HoursDetail]","qryHoursDetail","[HoursDate]=([Monday])&quot,0) and [Monday] is the most recent weeks Monday. For Tuesday, I have ...[HoursDate]=([Monday]+1...
The text boxes Mon, Tues...Sun are not visible.

The problem is that the text box that adds together(Most recent weeks Hours), [Mon] thru [Sun] inconsistenly gets and # Error showing in it, when I am on a particular record in the form, though that records date may before [Monday], so it shouldn't show in the most recent weeks hours. If I retype the hours amount, the error goes away, but if I change the employee and then go back, the error typically shows up when I have selected a totally different record?!##$#

Any suggestions please....

Nishan

 

[karassik]

I thought I might repost so, someone else who has had a similar experience could post.