I can see the problem coming

[Oldsoftboss]

I have built a ticket generating DB that empties one field in a table each time before a new ticket series is made. I've done this with an update query that works fine but for one foreseen problem.
Each time the query is run a msgbox appears warning the records are about to be deleted. I've turned this off via the tools-options menu on my PC but what happens on every PC this is installed on. Is there a way to automatically turn off these msgs via code as I think forcing the end user to make these changes is a bit unprofessional.

Thanks in advance

Dave.

 

[yellow]

Docmd.SetWarnings False

To turn them back on:

Docmd.SetWarnings True

 

[Oldsoftboss]

New this worked for general code but it didn't cross my mind for queries. Thanks for prompt reply.

Dave