#Name? Error Main Form With Subform Calculations

[burrina]

Both the main form and subform have a single table record source with NO missing or miss-named fields.
I can't figure out what is causing this. I know what the error means but I don't see anything wrong.
Here is a list of my field names and with control source. Table(s) used as record source is tblOrders (Subform) for Customer Orders and tblMonthID (Main Form) for list of Months. Do you see something I don't?

ON Main Form
(Gross Sales) =[frmSalesTaxSubform].[Form]![Gross]
(Local Tax Due) =[frmSalesTaxSubform].[Form]![Local GT]
(State Tax Due) =[frmSalesTaxSubform].[Form]![State GT]
(Sales Tax Due) =[frmSalesTaxSubform].[Form]![Sales Tax]


On Subform

Calculated Fields: Name.Control Source

(Gross) =(Sum(CCur([Gross Sale])+[AppliedPayment]+[SalesTax]))
(SalesTax) =Sum([Sales Tax])
(State GT) =Sum(CCur([State Tax Due]))
(Local GT) =Sum(CCur([Local Tax Due]))
(AppliedPayment) AppliedPayment

Bound Fields: Name/Control Source

(State Tax Due) State Tax Due
(Local Tax Due) Local Tax Due


(Gross Sale) Gross Sale
(SalesTx) SalesTax
(OrderAmount) OrderAmount

[pbaldy]

Are you running into this?

nnz function

[burrina]

I am not using that? Should I ?

[pbaldy]

If it resolves the problem, yes. If not, no.

[burrina]

Dont see that it makes any difference

[pbaldy]

Can you post the db here?

[burrina]

Sure! Here it is.

[Rawb]

ON Main Form
(Gross Sales) =[frmSalesTaxSubform].[Form]![Gross]
(Local Tax Due) =[frmSalesTaxSubform].[Form]![Local GT]
(State Tax Due) =[frmSalesTaxSubform].[Form]![State GT]
(Sales Tax Due) =[frmSalesTaxSubform].[Form]![Sales Tax]

Shouldn't that be:
(Gross Sales) =Me![frmSalesTaxSubform].Form.[Gross]
(Local Tax Due) =Me![frmSalesTaxSubform].Form.[Local GT]
(State Tax Due) =Me![frmSalesTaxSubform].Form.[State GT]
(Sales Tax Due) =Me![frmSalesTaxSubform].Form.[Sales Tax]

[burrina]

That has NO effect!

THE Problem lied in the format: $#,##0.0000;-$#,##0.000

This Solved it since the original value returned was less than a penny and of course the value returned would be Zero. FYI

Thanks,