xuanxiang=alltrim(thisform.combo1.displayvalue) tiaojian=alltrim(thisform.text1.value) SQLCMD='select * from renshi where '+xuanxiang+'="'+tiaojian+'" order by renshi.编号' @SQLCMD
变量不能那么写的。 "select * from renshi where "& xuanxiang&"='"&tiaojian&"' order by renshi.编号"就好了。
电脑说无效的TOP。
还是再看看吧
tiaojian=alltrim(thisform.text1.value)
SQLCMD='select * from renshi where '+xuanxiang+'="'+tiaojian+'" order by renshi.编号'
@SQLCMD
"select * from renshi where "& xuanxiang&"='"&tiaojian&"' order by renshi.编号"就好了。