Private Sub Combo1_Change()
Dim rs As Recordset Dim strSql As String
Set conn = New ADODB.Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\数据库.mdb;User ID=; Jet OLEDB:database Password = tcd2002"
Set rs = New ADODB.Recordset
strSql = "select * from ProductRecord where 字段 like '%" & Combo1.Text & "%'"
rs.Open strSql, conn, adOpenStatic, adLockOptimistic
Combo1.Clear
Do While Not rs.EOF
Combo1.AddItem rs.Fields("字段"), False
rs.MoveNext
LoopEnd Sub
为什么这个不会自动下拉啊?哪位高手帮忙看看
Dim rs As Recordset Dim strSql As String
Set conn = New ADODB.Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path + "\数据库.mdb;User ID=; Jet OLEDB:database Password = tcd2002"
Set rs = New ADODB.Recordset
strSql = "select * from ProductRecord where 字段 like '%" & Combo1.Text & "%'"
rs.Open strSql, conn, adOpenStatic, adLockOptimistic
Combo1.Clear
Do While Not rs.EOF
Combo1.AddItem rs.Fields("字段"), False
rs.MoveNext
LoopEnd Sub
为什么这个不会自动下拉啊?哪位高手帮忙看看
加一个文本框来做Private Sub Combo1_Click()
Text1.Text = Combo1.Text
End SubPrivate Sub Text1_Change()
Dim i As Integer
Combo1.Clear
For i = 1 To 10
Combo1.AddItem i
Next i
End Sub
List1.Visible = False
End SubPrivate Sub List1_Click()
Text1 = List1.List(List1.ListIndex)
List1.Visible = False
End SubPrivate Sub Text1_Change()
Dim i As Integer
List1.Clear
For i = 1 To 10
List1.AddItem i
Next i
List1.Visible = True
End Sub