emory only recordset bound to a grid?
Posted on 2000-03-15
I got the following code this morning and it is working perfectly:
Dim r As ADODB.Recordset
Set r = New ADODB.Recordset
r.CursorLocation = adUseClient
r.Fields.Append "IntegerField", adInteger
r.Fields.Append "StringField", adVarChar, 30
r.Fields.Append "DateField", adDate
r.Fields("IntegerField").Value = 3
r.Fields("StringField").Value = "It Works"
I am rather new to this so if this questions sounds silly, I apologize <g> I am able to populate the recordset but now I would like to present it to the user. I have tried setting the datasource or recordsource of a datagrid control to "r" but it rejects that. Can someone clear this up for me. I thought r was a recordset object and should be useable