是不是符号输错了? rs.Open "select * from zh where id='" & text1.text & "'", db, adOpenStatic, adLockOptimistic
"select * from zh where id='" & text1.text& "'", db, adOpenStatic, adLockOptimistic