7,765
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
Private Sub Combo1_Click()
SendKeys "{Enter}"
Debug.Print "Click"
End Sub
Private Sub Combo1_KeyPress(KeyAscii As Integer)
Debug.Print "KeyPress"
End Sub
Private Sub Form_Load()
Combo1.AddItem "123"
Combo1.AddItem "456"
End Sub
Private Sub Form_Load()
Dim rschk As ADODB.Recordset
Dim sqlstr As String
Set rschk = New ADODB.Recordset
sqlstr = "select * from location "
rschk.Open sqlstr, Form1.connchk, 1, 1
If Not rschk.EOF Then
Do While Not rschk.EOF
Combo2.AddItem Trim(rschk("location"))
rschk.MoveNext
Loop
Else
Combo2.AddItem "尚未添加"
End If
rschk.Close
Set rschk = Nothing
Combo2.ListIndex = 0
End Sub
Private Sub Combo2_Click()
SendKeys "{ENTER}"
End Sub
Private Sub Combo2_KeyPress(KeyAscii As Integer)
msgbox "触发事件!"
End Sub