adRs.Open "select * from objects", adCon
While Not adRs.EOF
CobType.AddItem adRs.Fields(1).Value
adRs.MoveNext
Wend假设adRs.Fields(1).Value的值为:
a
b
c
d
…现在要使CobType的选中项为c,但不知道ListIndex的值,请问怎样实现?
While Not adRs.EOF
CobType.AddItem adRs.Fields(1).Value
adRs.MoveNext
Wend假设adRs.Fields(1).Value的值为:
a
b
c
d
…现在要使CobType的选中项为c,但不知道ListIndex的值,请问怎样实现?
While Not adRs.EOF
CobType.AddItem adRs.Fields(1).Value
With Combo1
If .List(.NewIndex) = "c" Then
index = .NewIndex
End If
End With
adRs.MoveNext
WendCombo1.ListIndex = index
我试了,逐条运行,但是没有使.List(.NewIndex) = "c"成立的记录。也就是index = .NewIndex没有执行。