关于集合的怪问题
小弟遇到下面的奇怪问题!!
每次进入For each循环对集合进行遍历时,总会出现错误
“对象不可用”
为什么呢??
高手们帮帮忙啊!!!!
''''''''在模块中定义下面的类型''''''''''
type LineRef
LineCtoNCol as new collection
LineNtoCCol as new collection
end type
global LineRef as LineRef
''''''''''''''''''''''''''''''''''''''
rs.Open "select distinct linecode,linename from test_linebasicinfo", gafcConnect
If rs.EOF = False Or rs.BOF = False Then
rs.MoveFirst
While rs.EOF = False
LineRef.LineCtoNCol.Add rs!linename, rs!linecode
LineRef.LineNtoCCol.Add rs!linecode, rs!linename
rs.MoveNext
Wend
End If
rs.Close
''''''infocombo为ComboBox
For Each LineInfo In LineRef.LineCtoNCol
InfoCombo.AddItem LineInfo
InfoCombo.ItemData(InfoCombo.NewIndex) = LineRef.LineNtoCCol(LineInfo )
Next