DataGrid

[mysql123]

I have used the DataGrid Control in a VB6 application that I wrote and am now doing a program using MS Access and would really like to use the DataGrid Control but am having problems. I have serched this forum for a solution but have found nothing useful besides the fact that I should not use it in MS Access because it is to hard. I would really like to use it and any help would be appreciated. Below is some code that I am using but I am receiving an error saying, "This rowset is not bookmarkable.":

''''''''''''''''''''''''''''''''''''''''''''
Private Sub Form_Load()
Dim dbOpenSQL As ADODB.Connection
Dim rsRAData As ADODB.Recordset

Set dbOpenSQL = New ADODB.Connection
dbOpenSQL.ConnectionString = "Provider=sqloledb; " & _
"Data Source=syr_sql;Initial Catalog=DataWH; " & _
"User Id=********;Password=********; "
dbOpenSQL.Open

Set rsRAData = New ADODB.Recordset
Set rsRAData.ActiveConnection = dbOpenSQL

rsRAData.Source = "Select Vendor, Description, " & _
"InvoiceNo from tblMDFSpiff"
rsRAData.Open , , adOpenStatic, adLockPessimistic

Set dgRA.DataSource = rsRAData
End Sub
'''''''''''''''''''''''''''''''''''''''''

Any help would be appreciated.

Thanks.

 

[johndweidauer]

Would you loose functionality if you just used a subform in datasheet view?