check status after update

[leahf via AccessMonster.com]

Is there a way to check the status after an sql update besides doing a select
statement to see if the fields were actually changed?

Thanks.
Leah

 

[leahf via AccessMonster.com]

Right after I opened this to the forum I found the answer. I am using
dbFailOnError.

If, however, there is something else that I should be using, please let me
know.
Thanks.
Leah

 

[Allen Browne]

Examine the RecordsAffected:

Dim db As DAO.Database
Set db = CurrentDb()
db.Execute strSql, dbFailOnError
MsgBox db.RecordsAffected & " reccord(s) affected."

 

[leahf via AccessMonster.com]

Hi Allen,

Didn't know about the RecordsAffected. Thanks.

Leah

Examine the RecordsAffected:

Dim db As DAO.Database
Set db = CurrentDb()
db.Execute strSql, dbFailOnError
MsgBox db.RecordsAffected & " reccord(s) affected."

Right after I opened this to the forum I found the answer. I am using
dbFailOnError.

[quoted text clipped - 6 lines]