Run Query Command

[mrbarker]

Hi there. I have a run query command button on my form, but as soon as I click it (or any of the other query buttons that use an icon) an error message pops up saying that Access has encountered a problem and needs to close. The funny thing about this, however, is that if I go into design view, open the on click event procedure, and then switch back to Form view without changing a thing, everything works fine. Are there any updates I need to install or is this a weird thing with 2007?

 

[dkinley]

If you have a form with no code in it other than your command button and associated query code does it work? If not, could you post the code behind the button?

-dK

 

[boblarson]

It is possible that you are suffering from some corruption. Is this database split (frontend/backend) and does each user have a copy of the frontend on their machine (not accessing it from the network)?

You could also try importing everything into a new, blank database shell and see if that helps.