The RunSQL method does just that, it runs the SQL query you've setup with the variable called "SQL". And because you've turned off the warnings prior to RunSQL, nothing will be returned. The query will run, and in the case of your example, delete the records that match the criteria from the specified table. If you comment out the line 'DoCmd.SetWarnings False', you should receive a message telling you the number of records that will be deleted and that if you proceed, the action cannot be undone. But it is possible the database properties may be set to not display this warning. To check this go to Tools|Options...|Edit/Find and check the settings in the Confirm group.
Darrell L. Embrey
|