if IsNumeric(datalist1.boundtext)=true then
adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext
else
adodc1.recordsource="select * from TABLE where f='" & datalist1.boundtext & "'"
endif
if IsNumeric(datalist1.boundtext) then
adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext
else
adodc1.recordsource="select * from TABLE where f=" & datalist1.boundtext & "'"
endif
在table表中f是什么类型的,如果是数值那么
adodc1.recordsource="select * from TABLE where f=" & val(datalist1.boundtext)
如果是文本那么
adodc1.recordsource="select * from TABLE where f='" & datalist1.boundtext & "'"