Access window opens and will not close

[ragtopcaddy via AccessMonster.com]

I've been pulling my hair out (what's left of it) for days now tracking down
the source of this Phantom Window problem.

Whenever I close my application, a second Access window opens up empty and
remains after my application has closed. The only way to get rid of it is in
the Task Manager.

I finally tracked down the culprit as described in an article cited by Tony
Toews which I found in a thread making a similar complaint. Here's what I
found, and it fixed my problem, I hope it works for you:

"The problem is caused by code behind a subform which references a boolean
control on the main form and evaluates it in an If Then statement as

If me.Parent!chkSomeCheckBox then

The resolution is to do the True/False comparison explicitly.

If me.Parent!chkSomeCheckBox = True then

- From Arvin Meyer"

Happy trails!

 

[ragtopcaddy via AccessMonster.com]

BTW, the chkbox control does not have to be on a subform. In my case it was
on the mainform and caused the same problem.