Security at the form field level.

[piasalady]

Is it possible to secure specific fields in a form so that only one person
can change them while leaving other fileds opento be changed by mulitple
users?

 

[Salad]

Is it possible to secure specific fields in a form so that only one person
can change them while leaving other fileds opento be changed by mulitple
users?

The syntax and command will be wrong but some logic like
If not memberofgroup("Mgt") then Cancel = True
There's a way to check if a user is a member of a group (check the
SeqFaq). You can put something like the above code in the OnFocus event.

 

[Tom van Stiphout]

On Thu, 8 Oct 2009 11:52:02 -0700, piasalady

You're not giving enough information. Is your application already
secured? How?

-Tom.
Microsoft Access MVP