Displaying Recordset on a Form

[EdMacDonald]

I'm trying to display the contents of an ADODB.RecordSet object on a form - read only.<br><br>I've tried to use a DataGrid but can't figure out how to add rows to the grid.&nbsp;&nbsp;Columns.Add works to add all the fields, but I can't figure out how to insert.<br><br>I tried accessing a row using DataGrid.Row = i but get a RecordSet not available error.<br><br>Is it possible to use this control unbound like this.<br><br>Thanks,<br><br>Ed

 

[EdMacDonald]

I managed to do it with the FlexGrid instead, by looping through all fields of all records and setting .text property.&nbsp;&nbsp;There's gotta be a better way.<br><br>Is there a way to bind the flexGrid to a <i>disconnected</i> ADO Recordset, so that modifications in the grid are reflected in the RS?<br><br>Thanks,<br><br>Ed

 

[Nachocat]

'Try this
With DataGrid1
.ClearFields
Set .DataSource = your ADODB.Recordset
End With