For I = 0 To 10000
If (Not Rs.EOF) Then
Combo2.AddItem Left((Rs(0) & " "), 12) & Trim(Rs(1))
Rs.MoveNext
End If
Next I
Label16.Caption = Trim(Mid(Combo2.List(Combo2.ListIndex), 11))
Set Rs = Rs.NextRecordset() '取下一个返回集
For I = 0 To 10000
If (Not Rs.EOF) Then
Select Case Trim(Rs(1))
Case 1
Combo5.AddItem Trim(Rs(2))
Case 2
Combo6.AddItem Trim(Rs(2))
Case 3
Combo7.AddItem Trim(Rs(2))
Case 4
Combo3.AddItem Trim(Rs(2))
Case 5
Combo8.AddItem Trim(Rs(2))
End Select
Rs.MoveNext
End If
Next I
Rs.Close
Text1.Text = Now
Combo1.Enabled = False
Frame1(1).Enabled = True
Command1.Caption = "重新选择"
Label19 = Trim(Left(Combo1.List(Combo1.ListIndex), 2))
Combo2.ListIndex = 2
Exit Sub
End If