Sorry, some pic parts are too small for me. It looks like you've got 2 left parentheses in the blackened expression and 1 right one but that can't be. I believe the type error will be due to a null (and likely cascades), but from where? Since I see nothing obvious (and don't see some of that very well at all) I'd suggest you open in form view and test the values of calculated fields to see what they are. You can either write a sub for this and output each calculated textbox name and value to the immediate window, or you can inquire directly as in
?Text74 and hit return to see what you get. If any return null on a new record, your Nz expression isn't working there.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.