Form Button loses functionality after Save

[gregu710]

I am working on modifications to a database, and before modifying the database, I save it under a new name so that if my modifications go horribly wrong, I have a functional database to go back to. One of my forms has a button which opens a new form for data entry, and then closes itself. It works perfectly in each version I have done up till now. I simply took my existing database, clicked File > Save As, and accepted the modified file name that Access gave me. I went in, opened the new working file which I had just created, and that form button no longer has any functionality. If I go back to the old copy it works just fine. The button functionality is via the following VBA code:



Private Sub Command5_Click()
DoCmd.OpenForm "MOTOR_STARTUP"
DoCmd.Close acForm, "Database_Startup"


End Sub

A little update, if I change these commands to a set of Macros using Embedded Macro, I don't have this problem....



Nothing terribly sophisticated so not sure what is going on....

[June7]

So you tried saving again and same thing happens?

[gregu710]

Yep. If I open it on another computer out on the production floor, the problem goes away, everything is fully functional. And now, when I try to recreate the problem it doesn't seem to be happening. The only thing I can think is that it was something in one of the local settings. I was playing around with the TrustCenter settings, but other than that, have only been working on VBA script for other stuff unrelated to the buttons which lost functionality.