Hi everyone

I have three fields which are set not to allow data entry in browse mode. Occasionally I need to be able to edit these fields, so I have to switch to layout mode, select the fields, check them to allow data entry, go back to browse mode, make the changes, back to layout, change back to disallow data editing, back to browse mode. It's all a bit of a hassle. Is there a way this can be scripted?

Many thanks

Milt

Their are a bunch of ways to do this, here are 3 really simple ones. I recommend #2

1) simply use a custom dialog box to pop up and fill them in.

2) you can use validate by calculation to keep the field locked, this requires a extra field thats not on the layout to use as the "lock" field

and you can use "not isempty(lockfield)" as the validation. use a script to toggle the lockfield..

3) you can use a script trigger so that only someone with certain permissions can edit the field

hope this helps

Auto Entry might also be an option I would use. You can change the allow entry by selecting/deselecting the check box "Do not replace existing values (if any)"

p.s Why is this in Scripts instead of Calculations?

In my app I have to press a button anyway, I guess it's whatever someone preferes..

:frantics:

Thanks for your suggestions - a good help.

Regards

Milt.