Private Sub Command1_Click()
Dim i As String
i = InputBox("请输入一个字符串")
Select Case i
Case "DVD"
Combo1.ListIndex = 1
Case "CD"
Combo1.ListIndex = 2
End Select
End SubPrivate Sub Form_Load()
Combo1.AddItem ("DVD")
Combo1.AddItem ("CD")
End Sub 为什么上面的程序可以运行。下面的就运行不了呢?Private Sub Command1_Click()
Set rec = New ADODB.Recordset
rec.open "select playtype from goods where goodsid=1001011", con
Select Case rec!playtype '为什么换成记录集了就不行了???
Case "DVD"
Combo1.ListIndex = 0
Case "CD"
Combo1.ListIndex = 1
End Select
End Sub
Dim i As String
i = InputBox("请输入一个字符串")
Select Case i
Case "DVD"
Combo1.ListIndex = 1
Case "CD"
Combo1.ListIndex = 2
End Select
End SubPrivate Sub Form_Load()
Combo1.AddItem ("DVD")
Combo1.AddItem ("CD")
End Sub 为什么上面的程序可以运行。下面的就运行不了呢?Private Sub Command1_Click()
Set rec = New ADODB.Recordset
rec.open "select playtype from goods where goodsid=1001011", con
Select Case rec!playtype '为什么换成记录集了就不行了???
Case "DVD"
Combo1.ListIndex = 0
Case "CD"
Combo1.ListIndex = 1
End Select
End Sub
不清楚我说明白否?