Total on Continuous form

[dirkg]

Hi all,

I have two continuous forms. On the one form I have a field in the form footer which has as Control Source "=Sum([WorkingTime])" On that form there's also a field called WorkingTime that has as Control Source "WorkingTime". On that form the sum works fine, also when I apply a filter on the form.

On the other form I have axectly the same controls. Also there the sum works fine when all the records are shown. However when I apply a form filter I get an "#Error" in the control with the control source "=Sum([WorkingTime])"...
I really can't find the difference between the two forms...any ideas?

Thanks a lot in advance.

Greetz,

Dirk