Private Sub DataCombo1_Change()
SQL = "SELECT * FROM 项目表 where
项目名称 like " & Chr(34) + "%" + Trim$(DataCombo1.Text) + "%" + Chr(34)
= adCmdunknow
Adodc3.RecordSource = SQL
Adodc3.Refresh
Set DataCombo1.RowSource = Adodc3
DataCombo1.ListField = "项目名称"
End Sub
以上是我正在使用的语句