你需要先添加记录到控件中: sub form1_load() Combo1.additem "a" Combo1.additem "b" Combo1.additem "c" Combo1.listindex=1 end sub运行后显示b
Dim rs As ADODB.Recordset Dim txtSQL As String Dim MsgText As String Set rs = ExecuteSQL("select * from TwSoft", MsgText) Combo1.ListIndex = 1 Do Until mrc1.EOF Combo1.AddItem rs.Fields("C_SoftName") rs.MoveNext Loop
sub form1_load()
Combo1.additem "a"
Combo1.additem "b"
Combo1.additem "c"
Combo1.listindex=1
end sub运行后显示b
Dim rs As ADODB.Recordset
Dim txtSQL As String
Dim MsgText As String
Set rs = ExecuteSQL("select * from TwSoft", MsgText)
Combo1.ListIndex = 1
Do Until mrc1.EOF
Combo1.AddItem rs.Fields("C_SoftName")
rs.MoveNext
Loop