742
社区成员
发帖
与我相关
我的任务
分享
Private Sub Combo1_Change()
Static bIsReEntry As Boolean
Dim khmc As String
If bIsReEntry Then Exit Sub
bIsReEntry = True
khmc = Combo1.Text
Call rsOpen1("select distinct kh from dm_wz where kh like '" & khmc & "%' order by kh ")
If rs.RecordCount > 0 Then
Combo1.Clear
Do Until rs.EOF
Combo1.AddItem rs.Fields("kh")
rs.MoveNext
Loop
Else
Combo1.Clear
End If
Combo1.Text = khmc '<-这里要还原文本'
bIsReEntry = False
End Sub
Private Sub Combo1_Change()
Dim khmc As String
khmc = Combo1.Text
Call rsOpen1("select distinct kh from dm_wz where kh like '" & khmc & "%' order by kh ")
If Rs.RecordCount > 0 Then
Dim i As Long
For i = 0 To Combo1.ListCount - 1
Combo1.RemoveItem 0
Next
Do Until Rs.EOF
Combo1.AddItem Rs.Fields("kh")
Rs.MoveNext
Loop
Else
Combo1.Clear
End If
End Sub
Private Sub Combo1_Change()
Timer1.Enabled = False
Timer1.Enabled = True
End Sub
Private Sub Form_Load()
Timer1.Interval = 500
Timer1.Enabled = False
End Sub
Private Sub Timer1_Timer()
Dim khmc As String
khmc = Combo1.Text
Call rsOpen1("select distinct kh from dm_wz where kh like '" & khmc & "%' order by kh ")
If rs.RecordCount > 0 Then
Combo1.Clear
Do Until rs.EOF
Combo1.AddItem rs.Fields("kh")
rs.MoveNext
Loop
Else
Combo1.Clear
End If
End Sub