Hi Rick and Alex,

I am posting this here because the comment section in the player failed to load.

Time Index 9:11
I am equally shocked. I tried it out myself in Access 2016 and it worked. When did it start working like this?
But one other thing. I dont see DoCmd.SetWarnings False but yet no warning pops up before the INSERT query. I guess you edited it out from the video. Or is that something new again?

Best regards,

MICAH

---

Reply from Alex Hedley:

I don't think Rich has created the necessary blog post yet for it to show.

Must be a 2016 thing, unless we missed it earlier, that will be so much easier!

Maybe it's been set to FALSE in an earlier video and not back to TRUE, if you have it in only one other place it runs for the whole db, which is why it's dangerous to add, always write both statements at the same time so you don't forget.