Dim nms() As String = {"身份证号码","办公地址"} Dim ep As String = "" For Each nm As String In nms If Tables("部门档案").current.isnull(nm) Then ep= nm Exit For End If Next If ep > "" Then messagebox.show(ep & "不能为空") Return End If
DataTables("部门档案").DeleteFor("身份证号码 Is null And 办公地址 Is null") DataTables("部门档案").Save() Forms("部门档案录入").Close