Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Controlled Access Form

Controlled Access Form

Controlled Access Form

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.

RE: Controlled Access Form

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:


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

Good Luck!


No Rows Returned

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close