Re: deny some fields from some users



"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

.