I am using ADO to display information in a mshflexgrid. I am using this grid because a normal msflexgrid doesn't seem to work with and ADO Datacontrol. I am trying to edit a specific row in the grid before it is displayed. I am using the following code:
For i = 1 To cnt
Adodc1.Recordset.Fields("No") = i
cnt is a counter which calculates the number of rows in the recordset.
It complains about EditMode, what am I doing wrong, how do I go about editing a specific column.
Another thing is how can you change the recordsource in the ADODC. It is set to "Select * from Table* but at a later stage I want to change that sql statement to something else, how do I do this? It doesn't seem to change the recordsource no matter what I try.
Please can someone help