I am trying to bound the datagrid to the ado recordset and it will not work for me. I have tried several different ways to make this work, including examples from msdn, but I must have something wrong somewhere.

Here is the part of my code that I cannot seem to get to work:

Dim cnInjury As New ADODB.Connection
Dim Rcinjury As Recordset
Dim ssql As String
Dim ncounter As Integer
Dim oText As TextBox
On Error GoTo ErrorFormLoad

'Open the DB
cnInjury.CursorLocation = adUseClient
cnInjury.Open "ct10ms", "tgiru", "tgiru"
ssql = "select * from tgirdba.Cost_Center"
Set Rcinjury = cnInjury.Execute(ssql)

'Add fields to the text boxes in the txtCC control array
For Each oText In txtCC
Set oText.DataSource = Rcinjury
Set DataGrid1.DataSource = Rcinjury
Next


If someone could please help me out I would greatly appreciate it!!!

Heidi