Orders subform with calculations produces #error before populated

[emtenzer]

I have a form with a subform for "sales". The subform uses some calculations and some dlookups to produce the cost of the sale on the form. They work fine, but before the sale is entered, they show #Error in the text box. Is there any way to hide these? Thank you.

 

[MajP]

It is hard to say without seeing your calculations. But likely you calculations in the new record use a value that is set to null. Look at your calculations and consider wrapping them or passing values wrapped in a NZ function which will change a Null value to zero or something else.

 

[emtenzer]

Thank you, I will try those steps.

 

[MajP]

Or post your calculations for a possibly better answer.

 

[emtenzer]

This is one:

=DLookUp("TaxRate","tblMiscellaneousItemsforSale","ItemID = " & [ItemKey])*[txtTotal

 

[emtenzer]

I got it! Thanks for the tip.