Hi All

I would like to know If I protect a field ( can not touch that field when click on that field) in browse mode ...but when in Find mode I would like to search on that field but that field is unmodifiable ...So how can in Find mode I can put it as modifiable?

IS there a way to do that?

Thanks all

Yes, and it's kind of slick. You can use the record level protections for Browse, Edit, and Delete. Create a field:

cEdit (calculation, number) =

Status(CurrentMode) = 1

In the password dialog, set the access for "Edit" defining the calculation to just be "cEdit" for the password(s) for which you desire this limitation.

The other, more traditional, way of doing this is defining a calculation field for each field you want to Find on but not edit and using that field on layouts.

-bd

What I mean is in field format in Browse mode ...I click at allow entry into field ( it means can not touch that field) . It does not do anything with password. So in Find mode I want to click to that field to search but I could not .. Do you have any ideas?

Thanks

I do this all the time in my solutions. First, make sure that Allow Entry into Field is unchecked in Field Format. This will make it necessary to define entry into the field via a script. Create a script called Enter(your field name) and script your parameters for entering the field. Finally place a transparent button over the field linked to the script.

In your example, you can check for Current Mode, switch to another mode and permit entry to your field:

If [status(CurrentMode)=0]

Enter Find Mode

GoTo Field ["Your Field"]

Else

Enter Browse Mode

End If

You can also control access to a field based on any criterion you can script. I sometimes allow entry to a field only for a given period of time or for certain users or groups. Fiddle around with it and have some fun.

Thanks alot it helps me alot

Anh Tran