on error resume next
cn.execute "update khxx set kh='" & txtkh.text _
& "'" where id='" & txtId.text & "'"
if err.number <> 0 then
txtip.text = inputbox("请重新输入IP","提示",txtip.text)
if txtip.text = "" then exit sub
resume
End if
on error goto 0
cn.execute "update khxx set kh='" & txtkh.text _
& "'" where id='" & txtId.text & "'"
if err.number <> 0 then
txtip.text = inputbox("请重新输入IP","提示",txtip.text)
if txtip.text = "" then exit sub
resume
End if
on error goto 0
cn.execute "update khxx set kh='" & txtkh.text _
& "'" where id='" & txtId.text & "'"
if err.number <> 0 then
msgbox "查询错误!"
exit sub
end if
on error goto ErrCn
cn.execute "update khxx set kh='" & txtkh.text _
& "'" where id='" & txtId.text & "'"
if err.number <> 0 then
msgbox "查询错误!"
exit sub
end if
on error goto ErrCn