March 1, 200421 yr I have a layout with some fields on it and I would like to block all other field if the status field has been filled in with concluded. After that no other user should be able to change any data on the layout. I
March 1, 200421 yr Hi, The easiest way I can think of is this - it's not very sophisticated, but it will do the job. Have 2 layouts that are identical but on the 2nd layout do not allow entry into any fields. When the user clicks to got the layout, do a check on the status field, if the status is "Concluded" go to the 2nd layout, if it isn't go to the original layout. As I said, not very sophisticated but it may help... Regards Ed
March 1, 200421 yr The technique Eddy mentions is also good for locking/unlocking fields - if you've got a place where people create records and then view them later, you can send them to the unlocked one to create records, then to the locked one when they are viewing. If they want to change data, they hit an "unlock" button, which takes them to the first layout... -Stanley
Create an account or sign in to comment