Controlled Access Form

[Pamy]

I would like to know how can i restrict certain user from editing the form. For eg, if the form status = "closed", only the Manager access is allowed to edit. If the form status = "open", everybody can edit. This is what i have written for the access formula but it doesn't work.

Type : computed
Formula : @if( status = "closed"; "manager";role)

* role: i have a computed text to indicate the type of access the user is holding.

please advise.

 

[lespaul]

Why not just use the Access Control List? Assign Editor to the people who need to be able to Edit, and Author to those who don't get to Edit.

There are also ways to subdivide the groups into Roles through the ACL, then you can use:

!@Contains(@UserRoles;"[Supervisor]&quot

to limit which Roles can see and do various tasks within your database.

Good Luck! Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned