Help with read only record script

[lostboyca]

I would like to make a check box that will allow me to make that record read only once the box is check. Can anyone please show me how

Lostboyca

[Philland]

The easiest way that I can tellyou is to create a navigation button that takes you to any record, and is part of any search script, that has an If/then statement that says if(box = yes), go to layout A, else layout B and create a duplicate layout with the fields formatted to not allow entry.

Phil

[ernst]

Or alternatively you can make one field to control access, i.e. ReadOnlyFlag , and have each field validate via a calculation like 'Case(ReadOnlyFlag = 1 , 0 , 1 )'

Or go to each field via a script that checks the ReadOnlyFlag field.

Ernst

[Ugo DI LUCA]

Agreed with Ernst that validation by calc is what you need here. You can get an example in the Russ Calcs Sample in the Sample Section (at least the old version had one !).

I'd only make a little addition to what Ernst suggest if you were to set the values of fields by script. Instead of the "or" in his post, use an "and" because scripts by-pass field validation.

[lostboyca]

I don't understand is there a way I can upload the fp5 db to you and let you modify it for me?

[Ugo DI LUCA]

See attached a sample file with 2 different settings (independant demos) and the 2 different scripts I mentionned before.

Hope this helps...

ReadOnly.fp5.zip

[lostboyca]

Great thanks it work as a charm

[Ugo DI LUCA]

Glad it was useful ...