EDIT restriction for data?

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

Guest

Access 2002. I have a tabbed for with some sub-forms. When the application
starts, it reads the Newtwork logon-name from the system. If that name is on
a list, I need to allow the user to EDIT data on the form, as well as add new
records. If the person is NOT on the list, I only want them to be able to ADD
NEW records, but never edit exiting ones.

Can someone please clue me in on how to do that? Thanks!
 
Look into the AllowEdits and AllowAdditions properties of the form.

After you have detrmined whether the current user is on your list, just set
these properties to True or False.

Steve
 
Back
Top