To edit records in a DB using the normal Data Control you start off with this code:
How do you edit records in a DB using a ADO Data Control?
The above ADO statement doesn't work.
The ADODC doesnt have an explicit Edit method. If your recordset is opened dynamically, you can automatically assign values to the various fields and just use the update method to commit the values to the database.
I always discourage people to use ADODC.
Try learning ADODB.It might mean extra code but it's much more clearer to think and write code in terms of ADODB because you have complete control.
ADODC doesn't permit you to achieve a lot of things.
That's why ADODB is used by Professionals for Database Applications.