Unbound text boxes show #ERROR on data entry line

[GraeagleBill]

As seen in the image below, the new record line is showing "#ERROR" in four of the unbound text boxes being calculated. Any ideas on how to approach this situation where the "*" new data entry line text boxes are empty, null or otherwise blank. (This is a continuous form)

Thanks,
Bill

[June7]

Could try Nz().

Is InvstID in the form's RecordSource?

=DSum("Share", "Ledgers", "InvstID=" & Nz([InvstID],0))

[GraeagleBill]

Is InvstID in the form's RecordSource?

Yes, that's the killer in all of this in that all of the calculation expressions contain record field names that essentially do not exist until there's a record, hence the errors.

I was trying to complete the development of this form using the "*" new line for data entry, largely for consistency with the rest of the user actions. I have other methods of introducing new records into a continuous form display and will pursue one of those methods if someone doesn't see a way to solve this.

Bill

[June7]

Actually, simple calcs should not error. The textbox would show blank (Null). The issue is with the DSum() trying to do a calc with incomplete search criteria. I just confirmed this in my db. The error propagates to other calcs that use the DSum() calculated value.

I also verified that Nz() DOES resolve the DSum() error.

[GraeagleBill]

=[tbCurrentValue]-DSum("[basis]","Ledgers","[InvstID] = " & nz(Forms!Portfolio!InvstID,0))

That did the trick on the 3 controls that used DSum.

Thanks,
Bill