Getting rid of warning messages for delete queries

[Stevestan1]

I have a delete query I linked to in a form. Everytime I click on the link, I get two warning messages about using the delete query. The first is "Are you sure you want to run this delete query" and the second is "You are about to delete XXX number of lines." Is there any way to eliminate these warning messages? Thanks.

[NeoPa]

You can either use these lines around your code :

Call DoCmd.SetWarnings(False)
Call DoCmd.RunSQL(...)
Call DoCmd.SetWarnings(True)

or, alternatively, use the .Execute method of the database instead :

Call CurrentDB.Execute(strSQL)

[Stevestan1]

Thanks, the code took out the messages

[NeoPa]

I'm pleased that helped :)