Access 2002 field-level security: limit access to form fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can we use the value in a form field to limit modify access to the rest
of the fields on the form?
 
Put something like this in the Current event of your form.

If Me.SomeTextBox = SomeValue Then
Me.SomeOtherTextBox.Enabled = False
Else
Me.SomeOtherTextBox.Enabled = True
End If
 
Thanks. This gives us a good start for our implementation. . . .and more
questions to consider about security design. . .whether to control access to
all other form fields or just certain form fields. . .

This will be fun when we try to control the access key field on the form
using the user IDs in the user-level security file.
 
I'm glad it helps. When you start using the IDs to controll access, you will
probablly want to use the Group people are a member of instead of the
user -- much easier to manage. There is information on how to do that in the
Security FAQ. There is a link to it on the security page of my website.
 
Back
Top