Change of state validation?

[wcrc]

To be honest I am not sure where to start on this:

I have a form that locks when the status control is set to "Closed", which is good.

The problem is if someone wants to go back and edit the information, there is nothing stopping them from just setting the status back to "Open", and changing everything.

The question I need to answer:

Is there a way to request a password to set the status from "closed" to "open", but not the other way around?

If you can get me going in the right direction, that would help.

Thanks

 

[mrabrams]

mini sample

If you can get me going in the right direction, that would help.

Well, the attached is VERY basic. It isn't the prettiest nor the best way to do it.
Just something I whipped up real quick.

The password is YourPassword

What it does is change the label from Closed to Open.

Remember - proceed with caution !

Michael

 

[wcrc]

Thank you mrabrams I think that will give me something to work with.