Form Buttons Not Working

[slndn]

I recently upgraded to Access 2007 from 2003. The upgrade was in June and went smoothly. I added a couple of drop down boxes to my form in August and that seemed to have gone fine as well. Suddenly, at least two weeks later, my form buttons are not working. I added the pathway to my database to the list of trusted locations. Everything I have read says this should work. This did not make a difference. I am able to edit forms, run queries and reports, and can add new records by entering data directly into tables but am not able to add new records, view details, close forms, or exit using my buttons/forms. Any suggestions would be greatly appreciated. Thanks!

 

[GinaWhipp]

Have you *Enabled All Macros*?

 

[slndn]

I do have all macros enabled in the trust center.

 

[pr2-eugin]

Sometimes, I have seen is that the Form Controls events might not be linked to the code anymore.. What I mean is that, if you go to the Form Design and click on the control the On Click event would be empty, although the event will still reside in the VBA code window.. I think this happened to me exactly as I moved over to a different version of Access.

The unfortunate solution (atleast that I found) was to click the buttons in Design view and enter [Event Procedure] in the On Click method..

 

[slndn]

For my details button (which is supposed to open a form from a list of records) it does say Event Procedure in the "On Click" area and this is the code that is listed:

Option Compare Database
Private Sub cmdDetail_Click()
End Sub

Doesn't seem like a lot of code to me but I am not well versed in code.

 

[pr2-eugin]

My doubt is someone deleted the code of course '"accidentally". Or the Database has been corrupted/some error occurred. If there was some error normally Access tries to recover a Backup. See if you have it somewhere.. If not I am afraid you have to do a lot of coding..

 

[slndn]

Thanks, Paul. Do you know how I would go about finding the backup?

 

[pr2-eugin]

Normally they are found just where the File is located.. The exact file name, with the Word BackUp.. If your file is sample.accdb, then the Backup would be.. sample_BackUp.accdb