Why does Access 2010 close when i click a command button on a form

Question

Hi To All,

I have a 2010 Access Database that is experiencing the following problem

When I click on any command button the entire application will close. If I try to open any certain forms the application will also closes

I have changed the trusted sites to enable macros.

I have used other 2010 databases without experiencing this problem

Answer 1

Thanks Bob,

I will use your suggestion

Answer 2

Did you convert this database from another version?  If so, I would suggest conversion by importing everything into a brand new, accdb file from the original and not using the Database Save As feature. 

If you didn't, then you may need to decompile.  First save a copy of the database so you can restore if something goes really bad.  Then follow the instructions here:

http://www.granite.ab.ca/access/decompile.htm

to decompile.  The instructions are shown for the older format but the process still is the same except for the paths and the file extension (accdb instead of mdb).