I have a customer using a custom 'PO Database'. It has been in use for a number of years, and the person that wrote it is long gone. They have come to me with a particular need.
I can usually figure this stuff out, but I'm so far off on this one, I need a finger to point me in the right direction.
Most everyone is setup as an author or editor, and there are some roles defined. (I don't really know what those roles do yet)
Their problem is that certain fields remain editable even after a PO has been approved. Now, apparently that is how it was setup, so no big mystery there. The question is though, how do you change a persons access to a particular field on a form, when they start off having access? It looks like a form just shows up in different views as it reaches certain stages of approval, so can I lock certain fields to read only when a document is marked completed?
Here is the view selection for 'Completed' which I think just indicates that it isn't one of the mentioned status' ...not sure if this helps.
SELECT Form = "Document" & Status !="Draft" & Status !="Submitted" & Status != "Paid"
I know this is just a sliver of what you would need to fix this, so again, I'm just looking to be pointed in the right direction.