[SOLVED] Form won't calculate totals

Form won't calculate totals

I am having trouble on the Work Orders Form to get the SubTotal to calculate correctly.

EDIT: I think that maybe my relationships got messed up or deleted and caused the form to "break" because it was working correctly about a week ago. I am just not completely sure and don't want to risk messing things up further.

The problem is occurring with the Work Order Form and the SubTotal field.

If you look at the Client Tina Rich and run the Work Order, everything works, but not with the other clients. The database in its entirety, is posted here: REMOVED... [Problem Solved]

Solution

I figured it out: I updated my SubTotal Control Source to omit non-zeros or nulls:

=Nz(DLookUp("[Services Total]","[Services Total]","[WOrderID] = '" & [txtWOrderID] & "'"),0)+Nz(DLookUp("[Parts Total]","[Parts Total]","[WOrderID] = '" & [txtWOrderID] & "'"),0)

Simple problem that broke my whole database...