Private Sub Form_Load()
Dim mrc As ADODB.Recordset
Dim txtSQL As String
Dim MsgText As String
Dim i As Integer
'为下拉列表框添加内容
comboSex.AddItem "男"
comboSex.AddItem "女"
txtSQL = "select * from class_Info"
Set mrc = ExecuteSQL(txtSQL, MsgText)
'添加内容到列表框
For i = 1 To mrc.RecordCount
comboClassNo.AddItem mrc.Fields(i)
mrc.MoveNext
Next i
mrc.Close
End sub这段代码中 comboSex.AddItem "男" 这句有什么问题啊
Dim mrc As ADODB.Recordset
Dim txtSQL As String
Dim MsgText As String
Dim i As Integer
'为下拉列表框添加内容
comboSex.AddItem "男"
comboSex.AddItem "女"
txtSQL = "select * from class_Info"
Set mrc = ExecuteSQL(txtSQL, MsgText)
'添加内容到列表框
For i = 1 To mrc.RecordCount
comboClassNo.AddItem mrc.Fields(i)
mrc.MoveNext
Next i
mrc.Close
End sub这段代码中 comboSex.AddItem "男" 这句有什么问题啊
comboSex你到窗口去看看
comboClassNo.AddItem mrc.Fields(i)
mrc.MoveNext
Next i
mrc.Close好像红色部分错误了,好像lz的意思是取所有的classno的记录,添加到comboclassno里面,可是,在记录集里面不应该这个用的,i是记录的顺序号,然后每次添加的是不同数据域的值。也许这里应该是comboClassNo.AddItem mrc.Fields(classno)吧