DoCmd.SetWarnings False

[ECEK]

Will putting DoCmd.SetWarnings False into my code when the code is already at a False state cause any errors?

 

[Minty]

No, but generally speaking you can and should code your way around needing to do that, as it hides all error messages.

 

[ECEK]

Thanks Minty
It's just easier at the moment as there are several permutations to go through.

 

[Minty]

The biggest problem is forgetting to turn them back on before all possible "exits", as you code will just silently fail., and you won't have a clue why.

Your better off to use a simple error handler and/or currentdb.execute for action queries to suppress any need for the messages to appear in the first place.