Hello
1. I wasn't sure where to put the Docmd.setwarnings False and Docmd.setwarnings True to disable Cascading Delete messages.
Currently, I've put them on OnDelete (FALSE) and AfterDelConfirmation (TRUE) is this sufficient?
2. Also even when I didn't turn setwarnings to False the Cascading message wouldn't consistently show up. Most of the time it wouldn't show and there was no pattern to when it would show up. However, the deletes were always made despite that warning not showing up.
NOTE: I checked my project for Docmd.setwarnings FALSE leaks and there were none.
This made my confidence in Access go down a notch. Access should be consistent and show the message each time if warnings are TRUE
3. Is there a way to turn off cascading warnings all together so I don't have to trap them?
As always thanks to all the support on this forum
1. I wasn't sure where to put the Docmd.setwarnings False and Docmd.setwarnings True to disable Cascading Delete messages.
Currently, I've put them on OnDelete (FALSE) and AfterDelConfirmation (TRUE) is this sufficient?
2. Also even when I didn't turn setwarnings to False the Cascading message wouldn't consistently show up. Most of the time it wouldn't show and there was no pattern to when it would show up. However, the deletes were always made despite that warning not showing up.
NOTE: I checked my project for Docmd.setwarnings FALSE leaks and there were none.
This made my confidence in Access go down a notch. Access should be consistent and show the message each time if warnings are TRUE
3. Is there a way to turn off cascading warnings all together so I don't have to trap them?
As always thanks to all the support on this forum