Dim con As Connection Dim rst As Recordset Private Sub Command1_Click() rst.Open ("Select * from TABLE1") rst.MoveFirst While Not rst.EOF Combo1.AddItem rst.Fields("姓名") rst.MoveNext Wend End SubPrivate Sub Form_Load() Set con = New ADODB.Connection Set rst = New ADODB.Recordset With con .Provider = "Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db.mdb;Persist Security Info=False" .Open End With rst.CursorLocation = adUseClient rst.CursorType = adOpenDynamic rst.LockType = adLockOptimistic rst.ActiveConnection = con End Sub
Dim rst As Recordset
Private Sub Command1_Click()
rst.Open ("Select * from TABLE1")
rst.MoveFirst
While Not rst.EOF
Combo1.AddItem rst.Fields("姓名")
rst.MoveNext
Wend
End SubPrivate Sub Form_Load()
Set con = New ADODB.Connection
Set rst = New ADODB.Recordset
With con
.Provider = "Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db.mdb;Persist Security Info=False"
.Open
End With
rst.CursorLocation = adUseClient
rst.CursorType = adOpenDynamic
rst.LockType = adLockOptimistic
rst.ActiveConnection = con
End Sub
不过还要记住,在重新初始话的时候一定要用Combo1.clear