Recordset problem

[hanski]

Hi.

I can add new fields via recordset into my datebase simply:

Database.addnew
Database!name = "My name"
Database!address = "My address"
Database.update

But how can I EDIT my data via recordset? I do not want to make any new
records, but I want to change data in my Database. If I put
Database.addnew it will always add a new reocord. Is it something
instead of addnew?


Hannu

 

[Brendan Reynolds]

Is this an ADO or a DAO recordset? DAO recordsets have an .Edit method -
navigate to the record you want to edit, call the .Edit method, and start
assigning new values. ADO recordsets don't have an Edit method, you just
navigate to the record you want to edit and assign new values to the fields.
Assuming, of course, you have an editable record to begin with, but it looks
like you already have one, as you're already adding new records.