Re: deny some fields from some users
- From: "Keith Wilby" <here@xxxxxxxxx>
- Date: Wed, 20 Jun 2007 13:59:05 +0100
"accessdesigner" <accessdesigner@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:813B1CC7-02E7-41ED-B07D-BDA078AAC6F7@xxxxxxxxxxxxxxxx
is there a way to have some users gain access to some fields on a form and
prevent other users access to those fields from the same form based on their
log-in ids?
Yes. In the form's Current event:
If CurrentUser = "whatever" Then
Me.Control1.Locked = True
Else
Me.Control1.Locked = False
End If
Keith.
www.keithwilby.com
.
- Prev by Date: Re: Beginner needs help with securing db and distributing
- Next by Date: Re: Using Windows Authentication
- Previous by thread: Re: Beginner needs help with securing db and distributing
- Next by thread: Re: deny some fields from some users
- Index(es):