verifying if recordset update worked

[Cameo]

How can you verify if the VBA statement "rst.Update" actually worked? I'm looking for something like the RecordsAffected check after a DoCmd.Execute.
Thanks.

 

[DJkarl]

Well I would make the assumption that if you did not generate an error then the update worked.

Or you could change your update to an update query then use the recordsaffected property.

 

[Steve R.]

I don't have a "real' solution for you. A quick test, see if the record count changed. A slightly better approach, use find with "record count" and "no match" to see if your record was added. Of course you would need to have a unique value to find. There is a "transaction" feature, but for now the way Microsoft writes this stuff, it is incomprehensible without spending a lot of time contemplating what it means.

I found this, Microsoft Data Access Objects (DAO) Reference, but I am not really in a position to look all through this.