MsgBox How Meny records updated

[zionsaal]

how can I create A msg box should show how many records the run sql
cmd just updated I have the set warnings off

thanks

 

[Allen Browne]

See:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

The example shows how to execute the query and display the
RecordsAffected in the MsgBox.