Hey all. I am having a problem that is odd. I have a DB Access 2016. in the db, I have a Class Module to
create an event when I switch between controls - reason is a bunch of controls on a form
and miles of code to do it the other way.

So anyway, when I close the form Access crashes. There is something in the Class_Terminate Sub (at least so I thought.)
I remove the sub and the crashing stops. Put it back and the crashing resumes.

I stepped through the code, and the Class_Terminate would run 3 times and then close the form.
But when I let it run without the break it crashes every time.

The code tests if a collection exists, then For/Next Loop to delete individual
controls from collection then get rid of the collection. I thought there is something in that,
but if I take all the code out, and just have a msgbox or something, and it still crashes.
I was wondering if there was something that was re-making the collection and it was in a perpetual
create collection/terminate collection loop that was causing the crash.

I poured through the code to try to find a place that the collection was being recreated, but cant find that either.

Here is the kicker. I had to go out of town and I transferred the failing DB from 1 machine to the other,
and there were no crashes with the exactly same DB.

---

Reply from Alex Hedley:

If you try and compile the code does this help?