Prevent prompts when running Delete Query

B

Bruceh

I'd like to run a query via
docmd.RunSQL("Delete * from tableX")
and would like to suppress all the prompts.

Can this be done?

TIA
 
N

Nikos Yannacopoulos

Use this instead:

CurrentDb.Execute "Delete * from tableX", dbFailOnError

HTH,
Nikos
 
Top