Has update query affected any records

[The Stoat]

Hello,

I'm running an SQL update query using docmd.runsql(). I've suppressed the alert using docmd.setwarnings false, but i need to know whether or not the query actually updated any records. Is there a way of doing this without creating a querydef and using the records affected property?


Thanks

The Stoat

 

[The Stoat]

I couldn't find a way of doing this without to many complictions so i used a temporary querydef. Ce la vie.