Command button doesn't work when DB is opened

[buckeye4]

I have a command button in a form that changes a "Status" field from "Pending" to "Inspected".
For some reason, every single time I close the database and re-open to operate it, the command button no longer works. So I have to re-create it and then it'll work for the duration I have the database open for that particular session.
How can I get it to work indefinitely so I don't have to re-create the button and embedded macro every time I open a new DB session?

Embedded macro:
Condition = [Status] In("Pending")
Action = Setvalue
Action Aruguments = [Status], "Inspected"

Action = Requery

[RuralGuy]

How about *importing* everything to a new, fresh db and see if the problem follows: http://www.btabdevelopment.com/ts/impnew

[SteveH2508]

Make sure that your database is in a Trusted Location.

[thhui]

Could you upload your testing sample database in mdb format
so that we could find out what the problem is ?