Controlled Access Form

Pamy · Nov 25, 2002

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 · Nov 26, 2002

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Controlled Access Form

Pamy

MIS

lespaul

Programmer

Similar threads

Part and Inventory Search

Sponsor