Simple Query Wizard causes ON GOT FOCUS error message

When I create a new database, and use the simple query wizard a few times, an error begins to occur.  Here are the details.

As soon as I attempt to select the table or query from the pull down box in the simple query wizard, I get this error message:

"The expression On Got Focus you entered as the event property setting produced the following error: The text you entered isn't an item in the list."

At this point the mouse cursor turns to a rotating hourglass and will continue to be an hourglass until I close the database and re-open it.
However, if I don't close the database, the application works just fine....except for the darn rotating hourglass is a bit difficult to work with.

If I do close the database, I have the same problem again the next time I try to use the wizard.

Any help?
grillmannAsked:
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.

stevbeCommented:
have you Repaired/Compact the database? what version of access?

steve
0
tdkellerCommented:
does the database have any forms in it?  You may want to check the VBA Editor to see if any code is running when you open the database.  One of your forms probably has a procedure connected to its OnGotFocus event.

If you find one, try commenting it out in the code by putting a single quote ( ' ) in front of the line.  Save the form and compact and repair the database and reopen it.  Then try the query wizard.

Tina
0
tcafiniCommented:
And in yoou direct windows write:

  docmd.Hourglass False

TC
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

grillmannAuthor Commented:
Access version 2002.

Repaired, compacted....no different.

No forms in the database.  Just tables and queries at the moment.

This is not a new problem.  It happens with all my databases.
0
stevbeCommented:
At this point I would suggest that you try re-installing Access.

Steve
0

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
stevbeCommented:
If re-installing Access fixed the problem then why the C grade, if it did not and you found another answer hat was it and you/or you can post a request in Community support to have the question closed without points being awarded.

Steve
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.