rs.update?

[asmith]

Hi everyone,

I'm getting quite comfortable adding new records through vba using the rs.new command but i'm wondering if there is a way to modify exhisting records using a similar method? Is there such a thing as rs.update?

[pbaldy]

It's

rs.Edit
'change values
rs.Update

[weekend00]

It's

rs.Edit
'change values
rs.Update

More details for you. Asmith,

rs.Edit
rs!fieldname=value
rs!fieldname2=value2
...
rs.Update

[asmith]

Thanks guys,

is it possible to add a WHERE function on the end of it, sort of like:

rs.edit WHERE field x = expression

[pbaldy]

You would open the recordset on an SQL statement that restricted the records as desired. An alternative would be to execute an UPDATE query that updated the records. I'd go that way if there are multiple records.

[asmith]

Beauty,

I used a SQL statement as i'm just doing one record at a time through a loop and it worked perfect.

Thanks guys,
Andrew

[pbaldy]

Happy to help.