你的字段名用year吗??
试一下这样
rs.Open "SELECT distinct * FROM tempdb where [year]='"&choice&"'", cn, adOpenStatic, adLockOptimistic
试一下这样
rs.Open "SELECT distinct * FROM tempdb where [year]='"&choice&"'", cn, adOpenStatic, adLockOptimistic
跟踪调试一下看看,下面的试一下rs.Open "SELECT distinct * FROM tempdb where [year]='" & choice & "'", cn, adOpenStatic, adLockOptimistic
rs.Open "SELECT distinct * FROM tempdb where year='"&choice&"'", cn, adOpenStatic, adLockOptimistic
若是数值型:
rs.Open "SELECT distinct * FROM tempdb where year="& val(choice), cn, adOpenStatic, adLockOptimistic