dbcondition = "select * from 班级名单 where " & k & j & l注意Where后面的空格必须有
if k="姓名" or k="……" then 'l是字符 dbcondition = "select * from 班级名单 where " & k & j & "'" & l & "'" else 'l是数字 dbcondition = "select * from 班级名单 where " & k & j & l end if
取条件时加上空格就OK了dim l '不跟变量类型 k =" " & CStr(Combo1.Text) j = " " & CStr(Combo2.Text) l = Val(Text1.Text)
dbcondition = "select * from 班级名单 where " & k & j & "'" & l & "'"
else 'l是数字
dbcondition = "select * from 班级名单 where " & k & j & l
end if
j = " " & CStr(Combo2.Text)
l = Val(Text1.Text)