condition in macros

[frcastro]

Hi,




I have a macro action that deletes a table . If I don't have the table it shows a error.

How can i make a condition that only deletes the table if it exists?


Thanks!!!

[maximus]

Dim strSQL as String

strSQL = "Drop Table Filtered"
On Error Resume Next
CurrentDb.Execute strSQL, dbFailOnError

Table name is Filtered.
The Table is Deleted if its is there. If it is not there No error message is Displayed.
Add the line highlighted in red.