Controlled Access Form
Controlled Access Form
(OP)
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.
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.
RE: Controlled Access Form
There are also ways to subdivide the groups into Roles through the ACL, then you can use:
!@Contains(@UserRoles;"[Supervisor]")
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