Error on moving between forms

[branston]

Hi,

I have the weirdest error occuring, and hopefully someone will be able to throw a few suggestions out there to why this is happeneing.

I have an access database which I have been working on for about a month. Everything works fine, however today I made a back up copy of it, and now when I open the database (original or copy) the main menu appears fine but whenever I click on a button I get the standard "MS Access has encountered an error and has to close" message.

BUT... if, when I go into the database I go into the VBA code and then come straight out of it again (without making any changes), the buttons on the menu work fine.

Any idea why this is happening?!

Thanks!

 

[John Big Booty]

Have you tried a Compact and Repair?

 

[branston]

Yes, I have.

 

[branston]

Seem to have fixed it by copying everything into a new database.

Thank you!

 

[John Big Booty]

Glad you got it fixed.