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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
If record exists, edit it? 2
can't add new record to sub-form (continuous) 7
Allow Edits to Subform 2
Combo Box for Data Entry 1
Error: Argument Not Optional 0
Creating Checkbox Fields For Every Record 0
Allow Edits 1

Back
Top