cm.commandtext="select distinct 户别 from {zh} where 户名=txt"楼主:上面这句是否改为下面的情况会好点,我认为txt 是文本变量,应该不能直接用吧!
cm.commandtext="select distinct 户别 from {zh} where 户名='" & txt & "'"