Wrong Window Closes

I have an Acceess 1007 database
When the user duoble click a control on my menu form the DblClick event open a query with
  DoCmd.OpenQuery ObjName, acViewNormal, acReadOnly
The query opens and displayes normaly, but when you click the CloseBox on the Query the Menu forms unload event fires and the Query window dows not Close
Why? and how do I stop it.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Attach a sample database that reproduces the issue. Tell us what to do to replicate the effect.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you compacted your database? In 07, click the Office Button - Manage - Compact.

Make sure your Office/Windows installs are fully up to date.

Was this a database that was upsized from 2003 or earlier? If so, you'd be well advised to build a new, blank db in 2007 (you can still use the .mdb format) and import everything into that new database.
kinseyAuthor Commented:
The database is an MDB being used in Access 2007.
I was'nt able to find a solution to the original problem but was able to work around it by setting the 'Overlapping Windows' option for Access.

Now when I switch back to 'Tabbed Wndows' I no longer have the problem.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Your workaround should have no impact on your issue. I'd strongly suggest you insure that you are not working with a corrupt database, as the behavior you report would indicate troubles with your project.

If this were mine, I'd immediately build a new, blank db in 2007 (use the older format) and import everything into that new database. Now Compact the db, then Compile, and then Compact again.
kinseyAuthor Commented:
I have imported to a new database and the problem stil exits in the tabbed windows mode.
Never have a problem in the overlapping windows mode.
I spoke too early when I said I no longer have the problem. After opening a few windows in tabb mode the problem re-surfaces.
I'll just use the overlapping windows. I like it better anyway.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I would suspect your "problem" has to do with the poor UI implementation of the Tabbed Windows in Access. It can be quite confusing to determine exactly which "x" you should click to close what window, and many people have done so incorrectly.

If you can verify (and replicate) that you are indeed clicking the correct "x" to close the relevant window, and that your expected window does NOT close, then it would seem you've discovered a glitch in the Access UI and should probably report that.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.