试试改成
ElseIf c.Name <> "_Identify" AndAlso c.name <> "业务跟单" Then dnew(c.Name) = r(c.Name)End Ifmsgbox(usna)
dnew("业务跟单") = usna
dnew("材料成本")=Tables("报价单.报价明细").Compute("Sum(金额)","订单编号='" & Tables("报价单").Current("订单编号") & "'")dnew("财务审核") = Nothingdnew("总经理审批") = Nothingdnew("订单量") = 10000