asked on

Edit Once Fields

I have 4 Fields on a request form. They are "Assigned To : Date Assigned : Date Due : Date Req Rec'd".

Here is the problem. These fields may or may not be field out when the document is new. There are 6 teams each with a few people doing the assigning. What I am looking for is a way for someone to fill out the Assignment information but not allow the person it is assigned to, to change the information on the form. I was hoping there would be something like a Edit Once command or something for the field. They need to be editable due to someone needs to input that data, but once put on the form, it should not be edited again.

Any help would be great! Thanks

ASKER CERTIFIED SOLUTION

marilyng

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CRAK

In the past, I've also seen a lot of people using controlled access secctions (computed) for such purposes.
In R7 I'd probably use an "input enabled" formula.
Formulas would be simular to marilyng's hide formulas.

SOLUTION

Sjef Bosman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marilyng

All good suggestions...:)

kali958

ASKER

Thanks guys, I knew you would have the answer. I am going to use both the suggestion of having the two fields, but hide when needed but also the 2nd part with the show := .....

Both answer together give me the solution I really needed. Thanks again!!!!