Access 2010 Forms, won't open

Why does a Form open from Design View, but not directly from the Navigation pane or from code?  When I try to open it from the Navigation window or from code, Access freezes (or goes into a loop, I can't tell which).  I can then only close it by hovering over the Access Icon, then over the instance icon that appears, and selecting the "x".  This form is in Split Form view, and used to work fine some time ago.  It's been a while since it was used, and we've upgraded from Office 2007 to Office 2010 in the meantime.

DoCmd.OpenForm "fm_Resolver_Spouse", acNormal, , "ContactID = " & DSContactID, acFormEdit, acDialog
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
It could be any number of things; the form being corrupt, the VBA associated with it corrupt, error in coding, lengthy processing, etc.

First, put a stop in the On Open and On Load events.

See if you then hit those events or not.

We'll take it from there depending on what you find.


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
Rey Obrero (Capricorn1)Commented:
have you tried doing a Compact and Repair?
David_W_RAuthor Commented:
Never safe to assume.  I do a compact and repair every day, but this problem developed since then I guess.  I got way too far into the problem before doing the obvious.  Thanks capricorn1, Rey Obrero for the sanity check.   Thanks, Jim Dettman for humoring me with the quick advice and guidance.
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.