给你个例子,不过我的是combo1和listbox组合形成你那样的效果的
combo1里的代码
Private Sub cmbDW_Change()
Dim strsql As String
List1.Visible = True
strsql = "select * from unit_table where unit_name like '%" & cmbDW.Text & "%'"
Set rs = ExecuteSQL(strsql, msgtext)
If rs.RecordCount < 1 Then
List1.Clear
rs.Close
Exit Sub
Else
List1.Clear
Do While Not rs.EOF
List1.AddItem (rs("unit_name"))
rs.MoveNext
Loop
rs.Close
End If
End Sub
listbox里的代码
Private Sub List1_Click()
cmbDW.Text = List1.Text
List1.Clear
List1.Visible = False
cmbDW.SetFocus
End Sub